To install MySQL manually in Linux, 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 groupsudo groupadd mysql
- Add
MySQL
(not the current user) toMySQL
user groupsudo 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 groupcd 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 MySQL 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.