PHPMyAdmin

RomeoS · 26 Feb 2006 at 01:27

Been trying to figure out what the hell is wrong with phpmyadmin for the past hour.

Basically, I forgot my MySQL root password, so i went about re-setting it, went ahead without a hitch and now my forums and other DB's can connect fine.

Needed to install a new script so fire up phpmyadmin and enter the root username and password. No joy! The blasted thing wont let me log in even though the info is 110% correct!

What is wrong with phpmyadmin?

MySQL: 5.0.18
PHP: 5.1.2 AND 4.4.2
PHPMyAdmin: 2.7.0-pl2

Immsy · 26 Feb 2006 at 10:20

Do you get the error message : Client does not support authentication protocol?

If so then you need to do the instructions on this page http://www.digitalpeer.com/id/mysql

RomeoS · 26 Feb 2006 at 13:01

Nope, just asks for username/password

If I press cancel, it returns "access is denied"

Augmented · 26 Feb 2006 at 16:53

Did you update the password in phpMyAdmin's configuration file [config.inc.php]?

RomeoS · 26 Feb 2006 at 17:25

Hit the nail on the head!

For some reason, phpMyAdmin erased the password and set its own default one "pma". Have no idea how or why it did that but now its fixed

Cheers!