[solved] PHPMyAdmin installation error

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
robster
Forum Contributor
Posts: 360
Joined: Wed Jul 16, 2003 8:28 am
Location: Sunshine Coast, Australia

[solved] PHPMyAdmin installation error

Post 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
Last edited by robster on Tue Sep 06, 2005 6:16 pm, edited 1 time in total.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post 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.
User avatar
robster
Forum Contributor
Posts: 360
Joined: Wed Jul 16, 2003 8:28 am
Location: Sunshine Coast, Australia

Post 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)
Post Reply