Linux-Noob Forums

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?

I was hesitant to rm the old mysql dirs, but I could not find another way so I did. It worked out ok. Removed old dirs, moved the new ones to the same location and done. I dd have to get some shared libraries from mysql.com but it was not that bad of a procedure.