Jump to content


Photo

Error: Mysql connection


  • Please log in to reply
2 replies to this topic

#1 Lassie

Lassie
  • Members
  • PipPipPip
  • Advanced Member
  • 394 posts

Posted 12 October 2006 - 07:14 PM

I have just upgraded from mysql 4.0 to 4.1 and now get the following error message:
Could not connect to MySQL: Client does not support authentication protocol requested by server; consider upgrading MySQL client:
Can anyone shed light on this please.

#2 craygo

craygo
  • Staff Alumni
  • Advanced Member
  • 1,973 posts
  • LocationRhode Island

Posted 12 October 2006 - 08:11 PM

You have to update your mysql password to use old style passwords. you have to do this thru the mysql command line

1. log in as root
2. mysql> use mysql
3. mysql> UPDATE user SET Password = OLD_PASSWORD('your_password_here') WHERE User = 'username_here' AND Host = 'hostname_here';
4. mysql>FLUSH PRIVILEGES;

Should be all set after that

Ray


#3 Lassie

Lassie
  • Members
  • PipPipPip
  • Advanced Member
  • 394 posts

Posted 23 October 2006 - 12:03 PM

Thanks Ray




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users