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 ...
-2
votes
0answers
9 views

phpMyAdmin install with php7 centos7 manually? [on hold]

So I am running php7 and centos 7 and I am looking to install phpmyadmin. If I add epel and run sudo yum install phpmyadmin I get an error saying my php versions conflict with what phpadmin requires. ...
-1
votes
1answer
25 views

PHP Issue in error.log

My website cannot be found when I search the web. So I decided to go into my error.log to look if I could find a solution. This is what I found: [Mon Jun 20 07:24:31 2016] [error] [client 37.26.128....
-2
votes
0answers
31 views

another phpMyAdmin 403 error

I have searched and searched days and hours online for a solution to my problem and I am coming up empty handed. Most issues I have found are people not being able to even get to the phpMyAdmin log in ...
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 ...
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 ...
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
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
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 ...
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
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
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
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 ...
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 ...
-1
votes
1answer
49 views

phpMyAdmin - make user which only sees databases they create

I am aware of how to grant a user access to only one database using phpMyAdmin, and I am aware of how to give a user access to create a new database using phpMyAdmin (using the Create privilege). ...
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 ...
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 ...
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 ...
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/...
0
votes
2answers
988 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 ...
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?
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
3answers
860 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 "/etc/apache2/conf-...
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 ...
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
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 ...
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 ...
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 ...
1
vote
1answer
174 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 /...
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 ...
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 ...
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 ...
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 ...
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 '...
-3
votes
1answer
105 views

Can't login into phpmyadmin but password is correct

I'm trying to login into my phpmyadmin but it keeps redirecting me back to the login page. My username password should still be correct becuase my website is still functioning and I can even login to ...
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 ...
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 ...
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 ...
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 ...
-3
votes
1answer
50 views

Edit MySQL my.cfn With phpMyAdmin [closed]

I want to edit my.cfn file. Can I do it with phpMyAdmin (Version 4.4.15) and where can I find this file?
-3
votes
1answer
69 views

Amazon EC2 vs Google App Engine [closed]

For a Vaadin App, that uses a MySQL database and must have lots of files uploaded, which cloud platform is better? Amazon EC2 or Google App Engine? Can I use phpmyadmin in both? Better in terms of: ...
0
votes
1answer
301 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 ...