MySQL Forums
Forum List  »  PHP

Re: Cannot get PHP and MySQL working
Posted by: Alex Pandre
Date: February 28, 2006 03:55PM

This is what help me but I have Apache 2.0.55/PHP 4.4.2/MySQL 4.1.18:
http://dev.mysql.com/doc/refman/4.1/en/old-client.html
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

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');

Instead of starting mysqld with the --old-passwords option go on 'MySQL Adminstrator:Startup Variables' window and in a Security tab check box 'Use old passwords'. Do not forget Apply changes.

You are welcome ;-P

Options: ReplyQuote


Subject
Written By
Posted
February 26, 2006 09:43AM
Re: Cannot get PHP and MySQL working
February 28, 2006 03:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.