MySQL4.1 user password problem
Add a new user on the server's mysql4.1, encounter this problem, and the index is posted to everyone: MySQL4.1 The following error occurs when connecting: Client Does Not Support Authentication Protocol RequestedBy Server; Consider Upgrading MySQL Client This is because the user authentication mode in MySQL4.1 is different from the previous, and the old Client itself with the PHP is not applicable. The solution is as follows:
#mysql -u root -p passwordEnter Passwod: xxxxxxx
MySQL> Update MySQL; mysql> Update mysql.user set password = Old_password ('Your Password') Where host = 'localhost' and user = 'your mysql username'; mysql> flush privilege; reloading permissions OK.
