Ubuntu does not provide an apt-get repository package for MySQL 5.5 on this older OS, however this is still a widely used long term support version. The following steps will upgrade an existing MySQL 5.1 apt-get version to a standard MySQL 5.5 binary.
Step 1. Remove existing MySQL 5.1 retaining data and configuration
sudo su - service mysql stop cp -r /etc/mysql /etc/mysql.51 cp -r /var/lib/mysql /var/lib/mysql.51 which mysqld dpkg -P mysql-server mysql-server-5.1 mysql-server-core-5.1 which mysqld which mysql dpkg -P mysql-client-5.1 mysql-client-core-5.1 which mysql dpkg -P libdbd-mysql-perl libmysqlclient16 mysql-common # This will not remove /etc/mysql if any other files are in the directory dpkg -l | grep mysql [ -d /etc/mysql ] && mv /etc/mysql /etc/mysql.uninstall cp -r /etc/mysql.51 /etc/mysql
2. Prepare configuration and required directories.
sudo su -
MYCNF="/etc/mysql/my.cnf"
grep basedir ${MYCNF}
sed -ie …[Read more]