Raised This Month: $ Target: $400
 0% 

MySQL auth errors...


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
slurpycof
Senior Member
Join Date: Nov 2004
Old 10-22-2005 , 16:04  
Reply With Quote #2

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

To solve this problem, you should use one of the following approaches:

*

Upgrade all client programs to use a 4.1.1 or newer client library.
*

When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
*

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Alternatively, use UPDATE and FLUSH PRIVILEGES:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

Substitute the password you want to use for “newpwd” in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.
slurpycof is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 23:38.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode