Question

How to install mysql server 5.5?

I want to install mysql server 5.5 on ubuntu 16.04 but i am getting an error “E: Package ‘mysql-server-5.5’ has no installation candidate”…Can any body guide me how can i install this older version of mysql…Thanks in advance.

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hi @kbrkhn09,

First download MySQL:

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

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 the tar file

sudo tar -xvf mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz

Move it to /usr/local

sudo mv mysql-5.5.56-linux-glibc2.5-x86_64 /usr/local/

Create mysql folder in /usr/local by moving the untarred folder

cd /usr/local
sudo mv mysql-5.5.56-linux-glibc2.5-x86_64 mysql

set MySql directory owner and user group

cd mysql
sudo chown -R mysql:mysql *

Install the required lib package (works with 5.6 as well)

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

Set root user password

sudo bin/mysqladmin -u root password '[your new password]'

Add mysql path to the system

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

Start mysql server

sudo /etc/init.d/mysql.server start
sudo /etc/init.d/mysql.server status

Enable myql on startup

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

Now login using the below command, start MySQL server if it’s not running already

mysql -u root -p