Ubuntu – Is it possible to install MySQL 5.5 or 5.6 on Ubuntu 16.04

16.04MySQLpackage-management

I recently upgraded to Ubuntu 16.04. Unfortunately I need to work MySQL 5.5 or 5.6. I tried many solutions to have MySQL 5.5 or 5.6 run on Ubuntu 16.04 like this Install MySql 5.6 on Ubuntu 16.04 .
But none of them is working.
Ubuntu detect the unmet dependencies but says "but it is not going to be installed" for 5.5 or says Package 'mysql-server-5.6' has no installation candidate…

Is it not possible to force an earlier version of MySQL on Ubuntu? Why is that?

Best Answer

Step by step guide* to install mysql 5.5.x on Ubuntu 16.04 Xenial-Xerus. Please see this documentation

See steps below:

Installing MySQL 5.5.51 on Ubuntu 16.06

Uninstall any existing version of MySQL
```
sudo rm /var/lib/mysql/ -R
```
Delete the MySQL profile
```
sudo rm /etc/mysql/ -R
```

Automatically uninstall mysql

sudo apt-get autoremove mysql* --purge
sudo apt-get remove apparmor

Download version 5.5.51 from MySQL site

wget https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz

Add mysql user group
```
sudo groupadd mysql
```
Add mysql (not the current user) to mysql user group
```
sudo useradd -g  mysql mysql
```

Extract mysql-5.5.51-linux2.6-x86_64.tar.gz to /usr/local

cd /usr/local
sudo tar -xvf mysql-5.5.49-linux2.6-x86_64.tar.gz

Create mysql folder in /usr/local

sudo mv mysql-5.5.49-linux2.6-x86_64 mysql

Set mysql directory owner and user group
```
cd mysql
sudo chown -R mysql:mysql *
```
Install the required lib package
```
sudo apt-get install libaio1
```

Execute mysql installation script

sudo scripts/mysql_install_db --user=mysql

Set mysql directory owner from outside the mysql directory
```
sudo chown -R root .
```
Set data directory owner from inside mysql directory
```
sudo chown -R mysql data
```

Copy the mysql configuration file

sudo cp support-files/my-medium.cnf /etc/my.cnf

Start mysql

sudo bin/mysqld_safe --user=mysql &
sudo cp support-files/mysql.server /etc/init.d/mysql.server

Initialize root user password

sudo bin/mysqladmin -u root password '111111'

Start mysql server
```
sudo /etc/init.d/mysql.server start
```
Stop mysql server
```
sudo /etc/init.d/mysql.server stop
```
Check status of mysql
```
sudo /etc/init.d/mysql.server status
```

Enable myql on startup

sudo update-rc.d -f mysql.server defaults

Disable mysql on startup (Optional)

sudo update-rc.d -f mysql.server remove

Add mysql path to the system

sudo ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

Now directly use the command below to start mysql
```
mysql -u root -p 
```

PS: One needs to reboot in order for the changes to take place.

Based on a Chinese blog

Related Solutions

Ubuntu – how to upgrade phptheadmin after installing thesql 5.6

The solution I found is to add a custom PPA and install phpmyadmin with mysqlnd without any problem like this:

sudo add-apt-repository ppa:nijel/phpmyadmin
sudo apt-get update
sudo apt-get install php5-mysqlnd

sudo apt-get remove  phpmyadmin --purge
sudo apt-get install phpmyadmin

Ubuntu – How install or uninstall half-installed thesql-client-5.6 on/from ubuntu 15.10

I had the same issue on VM with Ubuntu 14.04. The only thing worked for me is similar to what Richard Uijen has suggested:

sudo apt-get --purge remove mysql*
sudo apt-get autoremove mysql*
sudo rm -rf /etc/mysql/
sudo rm -rf /var/lib/mysql/
sudo apt-get clean
sudo apt-get update
sudo apt-get install --reinstall mysql-client-5.6

Basically you need to remove all mysql packages (mysql*), clean and install again

After that I could install php7 mysql client without any issues

sudo apt-get install libapache2-mod-php7.0 php7.0-mysql

Best Answer

Related Solutions

Ubuntu – how to upgrade phptheadmin after installing thesql 5.6

Ubuntu – How install or uninstall half-installed thesql-client-5.6 on/from ubuntu 15.10

Related Question