Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [phpmyadmin]

phpMyAdmin is a popular tool for administrating MySQL (and similar) databases

PMA is best known as a GUI for managing not only the data within a database, but the table structures as well. Because and other MySQL forks are similar enough they can also be administrated with this tool.

https://www.phpmyadmin.net/

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

Questions about this tool should be focused on the problems with setting it up and not using it to manage the database.

217 questions
0
votes
1 answer

phpmyadmin creates the config.inc.php at http://localhost and not the config folder

I have followed the tutorial here to install mysql locally on mac Sierra but the phpmyadmin seems not to care creating the config.inc.php based on the above guide in the config folder which we create within the phpmyadmin folder. Instead it creates…
developer
  • 555
  • 2
  • 8
  • 16
0
votes
1 answer

PHPmyadmin doesn't work on document root after successful Varnish install

Last week I installed Varnish and my websites are now working fine with it - I can navigate and change them without error. Back when I installed it, I putted Varnish on port 80 and moved Apache to port 8080. I later noticed that if I run the…
user415736
  • 3
  • 1
0
votes
3 answers

configure nginx to so all domain can /phpmyadmin

I'm triyng to setup nginx so every vhost can access phpmyadmin like so example.com/phpmyadmin I tried using this configuration but no luck this is my default file server { #return 404; location /phpmyadmin { root…
phper
  • 155
  • 9
0
votes
0 answers

Inserting values on mysql produces 'a foreign key constraint fails'

I'm running Yetiforce which is built on vtiger, I am needing some help moving some database lines across. I am getting this error when i do a simple export and import.( in Vtiger-Attachments table) INSERT INTO `vtiger_attachments` (`attachmentsid`,…
stoneseraphim
  • 3
  • 2
0
votes
1 answer

HTTP Post randomly cut (begins with PhpMyAdmin mysterious error)

This is the strangest error I have ever seen. I have a problem with PhpMyAdmin. When I tried to export the database, I got an HTML file with an error message instead an SQL file. The message is: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET…
Theos
  • 51
  • 10
0
votes
0 answers

Can't install phpmyadmin with yum RHEL 6

I'm having difficulty getting phpmyadmin installed on a RHEL 6 server. I have tried to use on specific repo and have even tried installing the missing packages from another repo. I have still not been able to get this working. Here is an output from…
weggie
  • 101
  • 1
  • 1
0
votes
1 answer

phpMyAdmin new user can't connect to database

I created a user in phpMyAdmin and I only want to allow query, insert and update operations, and in my php file I am trying to connect to the MySQL database but always get the error Warning: mysqli::mysqli(): (HY000/1045): Access denied for user…
hakuna matata
  • 101
  • 1
0
votes
1 answer

Force Remote Login phpMyAdmin

I want users to be able to access phpMyAdmin from any computer. There are multiple users and I want to require login. It would definitely be OK to have remote access only. (All I would need do to use it locally is to use the remote address.) Remote…
Roger F. Gay
  • 101
  • 4
0
votes
1 answer

RHEL patch => phpMyadmin errors 5.5+ required

A recent RHEL patch has broken our server's config and various other issues. One specifically is phpMyAdmin throws the following error: PHP 5.5+ is required How would an upgrade of RHEL downgrade PHP or would it alter PHP at all?…
Cjust689
  • 1
  • 2
0
votes
2 answers

Can't get phpMyAdmin working

I've installed phpMyAdmin on a VPS running Apache 2.2.15 and PHP 5.6.27 on CentOS 6.8 After allowing web access via the httpd conf file I keep getting the following message from both the index page and the setup page. Cannot start session without…
Richard Grevers
  • 167
  • 1
  • 12
0
votes
1 answer

Cannot configure phpmyadmin vhost

With Apache 2.4, PHP7 & Phpmyadmin on a Windows Server 2016 VM: unable to properly configure phpmyadmin to be accessible as path from site. Site is a Symfony application that throws a 404 when site/phpmyadmin is requested. mod_alias is…
geoB
  • 105
  • 6
0
votes
1 answer

Phpmyadmin 404 not found on Apache 2.4

I can't seem to get phpmyadmin to work correctly with my current Apache/2.4.7 (Ubuntu:Trusty) setup. Phpmyadmin installed correctly, and I've included the /etc/phpmyadmin/apache.conf file in the VirtualHost itself, but navigating to…
Odyss3us
  • 375
  • 1
  • 3
  • 8
0
votes
1 answer

PHPMyAdmin - 500 Internal Server Error - Windows Server 2012 R2 - IIS 8

I have Windows Server 2012 R2 and IIS 8 as a Web Server and Operating System. I installed PHP 7 and it works great I could view the index.php file when created. I also installed MySQL Community Server on the system and that also works. Although…
spexops
  • 11
  • 1
  • 3
0
votes
1 answer

phpMyAdmin - blank page with no errors on Debian8, php7.0-fpm

phpMyAdmin does not display the login page on my server: OS: Debian 8.6 Jessie PHP: php7.0-fpm Webserver: Nginx 1.10.1 When I look at source code, it contains login form but for some reason all browsers (Firefox, Chrome, Opera) instead of login…
tfstfs
  • 1
  • 1
0
votes
1 answer

phpMyAdmin authentication issues on upgrade to phpMyAdmin-4.0.10.17-2.el6

I've run into an issue where a routine upgrade of phpMyAdmin to phpMyAdmin-4.0.10.17-2.el6 from 0:4.0.10.16-1.el6 on CentOS 6 causes some strange behavior with logins to a mysql server. Basically, users are unable to consistently login. I've tried…
Chlorus
  • 13
  • 3
1 2 3
…
14 15