Can't login to phpMyAdmin

PHP
1

Hi,

My phpmyadmin suddenly started giving me a “Cannot log in to the MySQL server” error. The MySQL server is already running fine, but i still can’t login. Anyone know how to fix this? It’s on a local web server by the way.

2

Have you made any changes to PhpMyAdmin or MySQL?
Try looking at the PhpMyAdmin configuration file, and using those settings to try to login to MySQL via the command line, or MySQL Administrator program. Can you get access that way?

3

Try adding old_passwords=1 to /etc/my.cnf

4

And how can i login to MySQL via the command line? i’m using XAMPP by the way.

5

you may be having the same problems I had after I added a password to my MySQL login. You need to go to the phpMyAdmin folder and edit ‘config.inc.php’. Change the line

 $cfg['Servers'][$i]['password']      = '';

and insert your password. If, ofcourse, this is the problem you are having. If not then I don’t know!

6

Look config.inc

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';

Change this to

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';