Page 1 of 1

Connecting to mysql with phpMyAdmin

Posted: Sun Mar 12, 2006 6:50 pm
by greeneel
Helo,

I am setup phpmyadmin 2.8.0.1 to run with already setup Apache 2.0.47 , php 4,3,3 and mysql 5.0.18nt on a XP professional Box.. I followed the instructions in the manual and set everythig up including creating the config.inc.php file to include the username and password for the Mysql Server. After all this I brough up http://localhost/phpMyAdmin/ in my browser and it gave me the following error:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

I am abit lost as to what client this is refering too, I think I have the last stable version on phpMyAdmin

any ideas?

Posted: Sun Mar 12, 2006 6:54 pm
by Burrito
try setting to the password to your mysql user to the old password hash.

Code: Select all

set password for root@localhost = old_password('somepassword');

Posted: Sun Mar 12, 2006 6:57 pm
by greeneel
hi, don`t mean to be ignorant but, this is set within my.ini ? ..

or i just run it from the cmd line?

Posted: Sun Mar 12, 2006 7:00 pm
by Burrito
no, just run that 'query' from within the MySQL cli...substituting (of course) your username and password that you want.

Posted: Sun Mar 12, 2006 7:00 pm
by greeneel
AHHHHHHH, LOLOLOL ROFL .... Thx Mate...

Posted: Sun Mar 12, 2006 7:17 pm
by greeneel
Hi ,

This is what i did to no avail,

used username and pass to login as root and executed the follwoing

-> SET PASSWORD FOR root@localhost = OLD_PASSWORD ('mypass') , this went through but I still couldn`t load phpMyAdmin..
Also when i load it up now in my browser im not going direct to the index.php file i am getting the "Index of /phpMyAdmin" folder and i would have to then find and click the index.php file..

weird..

Posted: Wed Mar 15, 2006 2:24 am
by jrd

For your password :

Input : SET PASSWORD FOR 'root'@'localhost' = old_password('987654321');
Output: Query OK, 0 rows affected (0.05 sec)

SET PASSWORD FOR 'root'@'localhost' = old_password('987654321');
Query OK, 0 rows affected (0.05 sec)


For the index, in the httpd.conf file, make sure that index.php is there.

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
# The index.html.var file (a type-map) is used to deliver content-
# negotiated documents. The MultiViews Option can be used for the
# same purpose, but it is much slower.
#
DirectoryIndex index.html index.html.var index.php

Posted: Wed Mar 15, 2006 8:46 am
by greeneel
ok ...

Posted: Wed Mar 15, 2006 8:14 pm
by jrd
ur welcome