openSUSE 11.1 to 11.2 Upgrade: Getting MySQL 5.1 to Work

A new version of MySQL, version 5.1, is part of the openSUSE 11.2 upgrade. Once you have got the basic openSUSE 11.2 upgrade working, you will discover to your horror that MySQL is not. There are a couple of changes made to MySQL at this release.

Firstly, The MySQL socket is moved to /var/run/mysql. So you will need to edit your /etc/my.cnf file. Open this file and change all occurrences of the socket path to reflect this new path. So, for example:

socket = /var/run/mysql/mysql.sock

This will occur more than once so make sure you change them all!

Secondly, you must remove the skip-federated option in the same configuration file. So locate this string and comment out.

#skip-federated

Finally, it makes sense to do a little housekeeping at the same time to avoid any potential conflicts. You should remove the old libraries from you system by launching Yast->Software Management, then searching for MySQL. Uncheck libmysqlclient15 and libmysqlclient_r15 and accept. Restart your apache server and you should be ready to go

# /etc/rc.d/apache2 restart