Page 1 of 1

[solved] PHPMyAdmin installation error

Posted: Tue Sep 06, 2005 6:12 pm
by robster
Well, it's not an installation error, I've actually reformated my windoze pc, re-installed windows, apache, php and mysql. They are all appearing to work except phpMyAdmin is having a bit of a complain.

I've had this exact error in the past but can't figuire out what it was I did. Note my config file is correct according to the mysql username/passwords and authentication method.

Code: Select all

Welcome to phpMyAdmin 2.6.2-pl1

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said: Documentation
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Does anyone know what this is? I remember it took me about a week to fix last time. hoooooold on, I think I remember, right back ;) Something to do with flushing the database or something strange?

Rob

Posted: Tue Sep 06, 2005 6:14 pm
by patrikG
You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Posted: Tue Sep 06, 2005 6:15 pm
by robster
found it, the thing to do is this:

Code: Select all

you entar in the mySql command line client and enter the following command SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');

example:
my user: is peter, my password: something and my host: localhost

the command will be:

SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something');"
taken from here: http://forums.mysql.com/read.php?11,6400,6701#msg-6701

(thanks google)