I have upgraded MySQL to version 5.1.48 on a number of CentOS based servers running different versions of Plesk. The versions of Plesk ranged from 8.3.0 all the way to 9.3.0.
IMPORTANT: After the upgrade, run
mysql_upgrade ––user=admin ––password=`cat /etc/psa/.psa.shadow`
to ensure all the required tables for MySQL 5.1.x gets created.
I also recommend running a
mysqlcheck ––optimize ––user=admin ––password=`cat /etc/psa/.psa.shadow` ––all-databases
to optimise all databases for MySQL 5.1.x after the upgrade completes.
It goes without saying, but it is a VERY GOOD IDEA, to backup /var/lib/mysql, before you start with the upgrade process.
Please note that since MySQL 5.0.12, MySQL adheres to the SQL:2003 standard. This may potentially break some SQL statements that appears to be valid SQL statements and that worked perfectly in MySQL 4.x.
Lastly, I picked up one error with one database on one server, so far:
When clients try to access their database via “DB WebAdmin” in the Plesk control panel:
MySQL said: Documentation
Non-static method PMA_Config::isHttps() should not be called statically
The fix is simple and published at the following URLs:
http://kb.parallels.com/en/1869
OR
http://rackerhacker.com/2007/07/01/plesk-and-phpmyadmin-non-static-method-pma_configishttps-should-not-be-called-statically/