Connecting to mysql with phpMyAdmin
Moderator: General Moderators
Connecting to mysql with phpMyAdmin
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?
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?
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');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..
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..
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