Jump to content


Photo

Connecting to Mysql5 with phpmyadmin


  • Please log in to reply
2 replies to this topic

#1 greeneel

greeneel
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 13 March 2006 - 12:47 AM

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 [a href=\"http://localhost/phpMyAdmin\" target=\"_blank\"]http://localhost/phpMyAdmin[/a] 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?

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 13 March 2006 - 01:32 AM

If you have any access to your database, run this:

SET PASSWORD FOR root@localhost = OLD_PASSWORD('yourpw')
If you're not running phpMyAdmin as root, you can change it to whatever you're using.

#3 greeneel

greeneel
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 13 March 2006 - 05:50 PM

thx mate....




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users