Re: MySQL 4 & Old Password

[Michael Stassen]

Joey wrote:

> Is there a way to tell mysql 4 to defaul to the old style passwords instead
> of having to run this every time we add a user?
> 
> SET PASSWORD FOR  <mailto:'user'@'localhost'> 'user'@'localhost' =
> OLD_PASSWORD('passowordo');
> 
> Applications we develop in php, and phpMyadmin don't seem to work with the
> new style password.
> 
> Thanks!

Did you check the manual?
<http://dev.mysql.com/doc/mysql/en/password-hashing.html>
<http://dev.mysql.com/doc/mysql/en/old-client.html>

Michael