mysql_connect client doesnt support authentication protocol requested by server

[devWhiz]

I was told this was because of the new hashing algorithm in mysql after version 4.1

 

so I entered this query

 

SET PASSWORD FOR bommobco_cwbtest@siteip = OLD_PASSWORD('mypassword');

 

and I get this error

 

#1044 - Access denied for user 'bommobco'@'localhost' to database 'mysql'

 

why does it say "user 'bommobco'@'localhost'" when I put bommobco_cwbtest@siteip and database mysql when I clicked on the other database...

 

How can I get this to work?

 

Thanks

[mens]

Because bommobco is the user you are currently authenticated as.

 

You are trying to change a password on an account, which is not the same as which you are authenticated as, and you do not have sufficient set of administrator privileges to do so.

 

PS. to see the username of the connected user, run query SELECT USER().

[devWhiz]

how do I fix the mysql_connect client doesnt support authentication protocol requested by server error

 

[devWhiz]

or how do I change the password hashing for the user in a certain db?

[mens]

  Quote

or how do I change the password hashing for the user in a certain db?

 

UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='bob';
FLUSH PRIVILEGES;

 

Source(s): http://dev.mysql.com/doc/refman/5.0/en/set-password.html, http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html

[devWhiz]

#1142 - UPDATE command denied to user 'bommobco'@'localhost' for table 'user'

 

what the fuck man

[mens]

Firstly, refer to the sources I gave you.

 

Next, try:

SET PASSWORD `bommabco` = PASSWORD('newpass');

 

It seems you don't have permission to change the password.

If that doesn't work, login with the root user and do it - if you don't have root access, contact the DBA.