2006-05-01, 09:07 PM
Hello all,
I don't quite know where to start on this upgrade. I want the upgrade to get two servers running the same version of MySQL. I have mysql 4.0 in /usr/local/mysql/ so how would I remove that install and replace with 4.1?
The whole reason for this is because of a snort error (I know jack about snort);
ERROR: database: mysql_error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
After reading the solution for some folks, with the following
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'SomeIP' AND User = 'root';
mysql> FLUSH PRIVILEGES;
Did not work
and
mysql> SET PASSWORD FOR 'root'@'SomeIP' = OLD_PASSWORD('newpwd');
ERROR 1133 (42000): Can't find any matching row in the user table
obviously did not work, I read I can just upgrade mysql to 4.1 to resolve the password problems, the trouble is...I have never upgraded mysql.
Help?