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

learn more… | top users | synonyms

8
votes
3answers
5k views

Is there any way to disable grouping databases in phpMyAdmin?

If you have db names like test_db1 test_db2 phpmyadmin would create a group test. The group appears in the left side-bar with related databases displayed under it. How can I disable this feature?
3
votes
1answer
79 views

phpMyAdmin export, half file compressed?

Okay, I have to admit, that I derped up. I've exported a database from a to-be-reinstalled server and didn't check that file. Now, that I try to import it, I've discovered something very strange, the ...
3
votes
3answers
3k views

phpmyadmin won't connect to remote MySQL instance

I have a LAMP stack box (CentOS 6) and another CentOS 6 box running mysql server. I've installed phpmyadmin on the LAMP box but I can not get it to talk to my SQL box at all. I have configured the ...
2
votes
2answers
3k views

Running phpMyAdmin and php-7 at the same time?

After upgrading php5 to php7, I get this error when I want to apt-get install phpmyadmin The following packages have unmet dependencies: phpmyadmin : Depends: libapache2-mod-php5 but it is not going ...
2
votes
2answers
83 views

Win7 apache2.4.9 phpmyadmin4.5.0.2 - an not connect for LAN [closed]

Everything is working fine - hosting a couple of my own sites, but would like to be able to maintain them from other PC's on the LAN. Works fine, except for phpmyadmin. Everything is set up to be ...
2
votes
1answer
330 views

phpMyAdmin uses port 80 on CloudFlare Flexible SSL

I currently have 3 websites on a dedicated server (running on one IP address). For one of the sites, SSL is active on the server and phpMyAdmin runs fine. After you log in you are redirected to the ...
1
vote
1answer
385 views

Updating phpMyAdmin

I'm running CENTOS 5.7 I have phpMyAdmin - 2.11.11.3 installed via yum. Trying to update to 3.5.6. If I run: yum list installed | grep phpMyAdmin I get: phpMyAdmin.noarch ...
1
vote
1answer
177 views

phpMyAdmin tries to install Apache

I'm playing up with installing new environments on my server, Nginx webserver in conjunction with HHVM. I installed both, then came to MariaDB and installed it as well. I can confirm server's working ...
1
vote
1answer
1k views

How to enable displaying “Choose column to display” in phpMyAdmin?

I read here you found a solution to the question in the title: How to enable displaying "Choose column to display" in phpMyAdmin? Could you explain how you enabled that? I'm using phpMyAdmin ...
1
vote
2answers
8k views

#1932 table 'phpmyadmin.pma_tracking' doesn't exist in engine

My box is Scientific Linux 7.1 x64 and xampp 5.6.14-3 x64. After installing xampp, I opened phpmyadmin and created databases and users, then I got this error message everytime: #1932 table ...
1
vote
2answers
12k views

phpMyAdmin error #2002 “Cannot log in to the MySQL server”, but works from console

The MySQL service on my CentOS 6.3 server works well. I'm using phpMyAdmin-3.5.8.1 from default repository. I have sites that can connect to the databases and are using them successfully. I can also ...
1
vote
3answers
5k views

phpMyAdmin: #1045 - Access denied for user 'root'@'localhost' (using password: YES).

I am getting in phpMyAdmin the famous #1045 error: Access denied for user 'root'@'localhost' (using password: YES). This is my /etc/phpmyadmin/config.inc.php: /** * Server(s) configuration */ $i ...
1
vote
1answer
97 views

Centos 6; phpMyAdmin 'Cannot log in to the MySQL server' after moving mysql.sock

I recently moved my mysql datadir from /var/lib/mysql to a new directory /home/mysql mounted on a new hard drive. For neatness sake I thought it'd be nice to place the tmpdir and socket on this new ...
1
vote
1answer
157 views

Why nginx alias returnes 404 on .php files?

This configutation works: location /phpmyadmin { root /usr/share/; index index.php index.html index.htm; location ~ ^/phpmyadmin/(.+\.php)$ { try_files $uri =404; root ...
1
vote
1answer
61 views

Find source of sleeping mysql connections

We have a very large number of PHP scripts running on our server that do a variety of things. Lately I've noticed that when looking in PHPMyAdmin there are a large number of connections to our MySQL ...
1
vote
0answers
36 views

PHPmyadmin Login without a password is forbidden by configuration even when entering password

Basically it is all in title. I did a clean install of CentOS7.2 (needed CentOS7 for running ARK). I made a LAMP server and it is working with tests, and then I installed PHPmyadmin. Whenever I try to ...
1
vote
0answers
29 views

Centos - PhpMyAdmin showing blank screen when trying to access it [closed]

I have just installed PhpMyAdmin, and when i try to access it it just shows a blank screen. I suspected this is because i followed a tutorial on how to secure php, so i reinstalled php to reset the ...
1
vote
1answer
51 views

Why nginx redirects after form submit?

I have conf: location ~ ^/secret(.+) { rewrite ^/secret(.+)$ /phpmyadmin$1; } location /phpmyadmin { root /usr/share/; index index.php index.html ...
1
vote
0answers
48 views

“Deny from all” not working

I have made following configuration on httpd.conf. But, any IP still can access PHPMyAdmin URLs/aliases. What have I missed? Is this related with "Alias" directive? Alias /phpmyadmin ...
1
vote
0answers
359 views

Why do I get an OpenSSL Error when connecting PHPMyAdmin through SSL?

I'm running PHP 5.6.11 on Apache 2.2 with OpenSSL 1.0.1 on Ubuntu 12. I've sucessfully setup SSL in Apache and MySQL. Now I want to set up a PHPMyAdmin and connect it through SSL. I don't really need ...
0
votes
2answers
59 views

Phpmyadmin on IP (not domain) and SSL

My phpmyadmin installation is like http://my-IP/phpmyadmin NOT http://mydomain1/phpmyadmin + http://mydomain2/phpmyadmin + http://mydomain3/phpmyadmin In other words my only phpmyadmin ...
0
votes
1answer
1k views

WAMP: phpmyAdmin gives access denied after I create password using cmd.exe [closed]

Hi I'm pretty new to the WAMP scene, I've just downloaded WAMP from: http://www.wampserver.com/en/download.php And got it installed with ease. I've set up a password to MySQL using cmd.exe on Windows ...
0
votes
1answer
52 views

phpMyAdmin on CentOS 7 with NGINX returns blank page

I have installed CentOS 7 in Virtual Machine with NGINX. PHP, MariaDB and everything else is installed and working fine. However, when I access the http://localhost/phpMyAdmin it shows blank page. ...
0
votes
1answer
1k views

phpmyadmin 403 Forbidden on Nginx server [closed]

I've installed phpmyadmin from remi repo on my Nginx server on Centos 6.x and then I linked "/usr/share/phpMyAdmin" to "/var/www/phpmyadmin". Main website is located on "/var/www/example_domain". now ...
0
votes
1answer
175 views

phpMyAdmin server description instead of hostname

I installed phpMyAdmin 4.4.8 (latest version) and I configured some MySQL host I can connect to. Servers are listed with the $cfg['Servers'][$i]['host'] value in the server list and I cannot find out ...
0
votes
1answer
2k views

phpMyAdmin can't connect to local MySQL server through socket '/var/lib/myseql/mysql.sock'

I'm trying to get phpMyAdmin working, connecting locally to mysql from Centos 6.3 running in VMWare Player. mysqladmin -u root -p status indicates that mysql is running. Both my.cnf and ...
0
votes
1answer
504 views

phpMyAdmin auth not with mysql credentials

I wish to set up an HTTP authentication for phpMyAdmin that does not use the existing mysql users. I have this options for $cfg['Servers'][$i]['auth_type'] string ...
0
votes
1answer
2k views

How to access phpmyadmin from other computer in the same network?

What do I configure in wampserver so that I could access phpmyadmin from other computer in the same network. And how do I access it from the browser?
0
votes
0answers
16 views

Phpmyadmin database warning

I succesfully create a LAMP server. However, when I log into Phpmyadmin (it works) I get a message saying "could not load user info database not...." When I installed phpmyadmin I pressed no to ...
0
votes
0answers
23 views

Invalid key length error when trying to connect phpmyadmin to remote MySql over SSL

I get these error messages when logging in to phpmyadmin instance Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ...
0
votes
1answer
43 views

Restricting IP address not working in phpmyadmin

In the default configuration of phpmyadmin with ISPconfig-3 on Ubuntu. Strange thing happens, "Order Deny,Allow" & "Deny from All" works for sub-directories (blocks all requests) but not for the ...
0
votes
0answers
30 views

Plesk + PhpMyAdmin: Allow a user to see all their databases

Initially each user on a domain could access all their databases on phpmyadmin, but now when you click on the "phpmyadmin" button, it only shows the database you opened instead of all the databases ...
0
votes
1answer
36 views

phpmyadmin fail2ban failed login log

I have a Debian server with phpmyadmin. I want to use fail2ban to block brute force attack. I have questions: How can I log the failed login attempts to log? Where to set that? I can only find ...
0
votes
0answers
95 views

PHPMYADMIN Multi Server Setup Issue - Server Choice Never Displayed

I have a phpmyadmin installed in my Ubuntu-14.04 LTS server. I want to manage other MySQL databases in different servers (all Ubuntu) across my VPC. I have enabled access to the servers using the AWS ...
0
votes
0answers
50 views

How can I configure both Laravel and PHPMyadmin on Nginx?

My Nginx server directive looks like this: server { listen 80 default_server; listen [::]:80 default_server ipv6only=on; root /var/www/laravel/public; index index.php index.html ...
0
votes
2answers
757 views

PHP 7 cannot connect to MySQL

I have compiled LAMP servers for hundreds of times. However I am facing issues with PHP 7. I compiled it properly, but it cannot connect to MySQL in localhost. phpinfo shows PDO and mysqli are ...
0
votes
0answers
104 views

phpmyadmin can't login with non-root users

I just started learning to manage Linux web hosting. After installed webmin/virtualmin on Ubunto 14.04, I used the install script of virtualmin to install phpmyadmin. The problem is, I can only use ...
0
votes
2answers
231 views

phpMyAdmin - 403 permission denied - Centos7

I have installed phpMyAdmin on my server running apache 2.4.6 on Centos7, I am getting error as You don't have permission to access /phpmyadmin on this server. my server ip is 62.210.xx.xx I am ...
0
votes
1answer
194 views

PHPMyAdmin “#2006 - MySQL server has gone away” during login

First: I've searched all over Google and although this looks like an infamous error, none is actually my case and hence no fix is available. OK so today I encountered this something weird: PHPMyAdmin ...
0
votes
1answer
57 views

Nginx & PhpMyAdmin standard practices

I'm currently migrating a small dev server from Apache to Nginx and I'm wondering about the "standard" way to manage PhpMyAdmin : I've simply symlinked the phpmyadmin folder to my nginx site root ...
0
votes
0answers
25 views

phpmyadmin ubuntu 14.04 login with no visible error displayed

I had working Phpmyadmin installed on Ubuntu 14.04 after some mysql installation I also reconfigured phpmyadmin. After that I am not able to login when I login with the root and the correct password ...
0
votes
1answer
53 views

Best Practice: What user should own “phpmyadmin” files/directories, and what should be the permission settings?

So I've searched for this answer, and can't seem to come up with anything relevant. So here goes: What is the best practice for ownership/permissions of the PHPMyAdmin files on a server? Thanks to ...
0
votes
0answers
96 views

Setting up phpMyAdmin on a 1&1 Managed Dedicated Server

I'm trying to set up phpMyAdmin on my Managed Dedi Server from 1&1 so that I don't have to log into my 1&1 Account to access the databases / so that my developers don't have to know my account ...
0
votes
1answer
265 views

phpmyadmin fails to load “PHP message: PHP Fatal error: Class 'PMA_Message' not found in /usr/share/phpMyAdmin/libraries/Message.class.php”

After upgrading some of the php libraries on our server phpmyadmin failed to load. I see the following error on my web browser when trying to access browser phpMyAdmin - Error Cannot start session ...
0
votes
0answers
173 views

phpmyadmin doesn't log access

I just wanted to install fail2ban also for phpmyadmin as described in another post. Then I found out that phpmyadmin doesn't log access on my apache. I installed phpmyadmin as follows: apt-get ...
0
votes
0answers
415 views

Random 502 errors only with phpMyAdmin throgh nginx/php-fpm, with php segfault

I'm using nginx and php-fpm on many servers. Some have php 5.4 with APC and others 5.5 or 5.6 with opcache. PhpMyAdmin on servers on 5.4 work without any problems. PhpMyAdmin on servers on 5.5 or 5.6 ...
0
votes
0answers
399 views

Cannot install php-mysql

I have a VPS with CentOS 6.6 x86-64 and ISPManager, PHP 5.4.43, Server version: 5.5.45 MySQL Community Server (GPL) by Remi and an version phpMyAdmin. I upgraded php from 5.3 to 5.4 and mysql from 5.1 ...
0
votes
0answers
297 views

How can I maintain logins to multiple hosts in phpMyAdmin

I'm attempting to setup phpMyAdmin to administer multiple MySQL servers from a single instance. I've modified the sample config that was included in ...
0
votes
0answers
118 views

Having trouble with PHPMyAdmin on Ubuntu

I'm having trouble getting PHPMyAdmin to run on our new Ubuntu14.04 LTS servers at Linode where we migrates sites from CentOS6.02 using VirtualMin/WebMin to back up and restore. PHP is fine and our ...
0
votes
3answers
762 views

phpmyadmin on apache2 reload: Unknown Authz provider: valid-user error

Aster standard installation of phpmyadmin on ubuntu 14.04 I found <site>/phpmyadmin doesn't work. After googling I found this can be solved with adding this line Include ...