+- Linux-Noob Forums (https://www.linux-noob.com/forums)
+-- Forum: Linux Server Administration (https://www.linux-noob.com/forums/forum-8.html)
+--- Forum: LAMP (https://www.linux-noob.com/forums/forum-83.html)
+--- Thread: Upgrade MySQL 4.0 to 4.1 (/thread-1998.html)
Upgrade MySQL 4.0 to 4.1 - MelRay - 2006-05-01
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?
Upgrade MySQL 4.0 to 4.1 - MelRay - 2006-05-02
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.