Cannot login to phpMyAdmin, no errors shown

Question

I have MySQL set up correctly on my linux computer, however I want a better way to input data into the database besides terminal. For this reason, I downloaded phpMyAdmin. However, when I try to log in to the phpMyAdmin from index.php, it doesnt do anything. It seems to just refresh the page without doing anything. I am putting in the correct MySQL username and password. What is the issue?

Here is a screen shot of what it shows after I click "go".

Answer 1

Make sure to set a 32 chars long random key in 'config.inc.php' in the $cfg['blowfish_secret'] value. That solved it for me.

Answer 2

In my case the hard drive was full.

Use df -h to check the space left on your hard drive, and if you want you can free some space by using the command sudo apt-get clean, which removes installation files.

I hope this will help some future users.

Answer 3

I ran these commands and it worked for me:

sudo service httpd restart
sudo service mysqld stop
sudo service mysqld start

Answer 4

This is a possible issue when the path to save php_session is not correctly set :

The directory for storing session does not exists or php do not have sufficient rights to write to it.

To define the php_session directory simply add the following line to the php.ini :

session.save_path="/tmp/php_session/"

And give write rights to the http server.

usually, the http server run as user daemon in group daemon. If it is the case, the following commands will make it :

chown -R :daemon /tmp/php_session

chmod -R g+wr /tmp/php_session

restart http server.

Answer 5

I fixed my issue on CentOS 7 with MariaDB and phpmyadmin I downloaded from offical phpmyadmin site by adding

session.save_path = "/var/lib/php/session"

to /etc/php.ini

and

chown -R :lighttpd /var/lib/php/session

I also restarted php-fpm and lighttpd after

Answer 6

1. Try searching the web for installation or setup guides for phpMyAdmin. Look at two or three of these and make sure you have covered all the required steps. (If you have already done so, please include which guides you have followed it in the question).
2. See if it helps to edit config.inc.php (acecoder mentioned this as well).
3. Check if this guide is of any help.
4. Which distro are you on? Try searching for the name of the distro you are using together with "phpMyAdmin guide" or "phpMyAdmin setup howto".
5. If you encounter errors along the way, post the error text here, if it's short (or paste via a pastebin-like site if it's long).