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

learn more… | top users | synonyms

16
votes
4answers
34k views

How to export result of a MySQL query using phpMyAdmin 3.4.3?

I've got a 30K row table When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K I want to export the grouped 7K rows as a new table, or save them as a CSV ...
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
84 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
87 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
372 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
388 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 2....
1
vote
1answer
187 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
9k 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
78 views

Phpmyadmin page shows lines of code on ubuntu server 16.04

After I installed PHPMyAdmin on my ubuntu server 16.04, instead of showing the PHPMyAdmin page it was showing lines of code which I think is the source code for the login page. Please, what am I doing ...
1
vote
1answer
126 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
175 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
64 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
47 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
31 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
55 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
51 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 /usr/share/...
1
vote
0answers
373 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
61 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
100 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
2k 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
184 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 config.inc....
0
votes
1answer
506 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 ['HTTP'|'http'|'cookie'|'config'|'...
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
1answer
25 views

[SOLVED]: HTTPS access to phpmyadmin DOWNLOADS INDEX.php instead of opening phpmyadmin

When I open phpmyadmin without encription, everything goes fine. however, if I switch to https, the browser downloads the index file. apache 000-default.conf as <VirtualHost *:80> ...
0
votes
0answers
15 views

phpMyAdmin reCaptcha error allow_url_fopen=0

I've got phpMyAdmin running on Nginx. I also enabled reCaptcha $cfg['CaptchaLoginPublicKey'] = 'secretkey' and $cfg['CaptchaLoginPrivateKey'] = secretkey'. I added the above to config.inc.php. As you ...
0
votes
0answers
37 views

phpMyAdmin asks for BasicAuth

When accessing the phpMyAdmin link (mydomain.com/phpMyAdmin/), I am being prompted with a BasicAuth pop-up. The phpMyAdmin/config.inc.php does not overwrite any defaults, therefore the config.default....
0
votes
0answers
13 views

Where are stored phpMyAdmin SQL import files?

When a data file (SQL, CSV, XML…) is imported with phpMyAdmin, is it in volatile or non-volatile memory? If it stored on hard disk, is it temporary? When the file is deleted and what is the default ...
0
votes
1answer
61 views

Replacing mysql with MariaDB

phpMyAdmin shows this version ! I am new to Linux and servers. I was using mysql 5.5 (was installed using third party repositories) as my DBMS and then I decided to replace it with the latest version ...
0
votes
0answers
20 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
43 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
51 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
35 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
38 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
108 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
60 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
989 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
120 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
248 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
226 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
59 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
27 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
58 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
103 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 ...