Install MySQL 5.6.xx on Ubuntu 18.04 & Ubuntu 20.04

MySql-5.6-installation guide.md

MySQL Download URL

https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz

Open the terminal and follow along:

• 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.6.46 from MySQL site

wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.46-linux-glibc2.12-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 it

sudo tar -xvf mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz

• Move it to /usr/local

sudo mv mysql-5.6.46-linux-glibc2.12-x86_64 /usr/local/

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

cd /usr/local
sudo mv mysql-5.6.46-linux-glibc2.12-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 libncurses5

• 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-default.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

• Reboot!

• 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

• REBOOT!

• Now login using below command, start mysql server if it's not running already

mysql -u root -p

OMG I've been fighting with the last version of mysql for 4 hours!!! now I arrive here and everything is solved, Thanks!!

Hi,

I could not able to start mysql in background with following command

sudo bin/mysqld_safe --user=mysql &

Output: ● mysql.server.service - LSB: start and stop MySQL Loaded: loaded (/etc/init.d/mysql.server; generated) Active: active (exited) since Wed 2022-06-01 17:51:40 IST; 1min 6s ago Docs: man:systemd-sysv-generator(8) Process: 968 ExecStart=/etc/init.d/mysql.server start (code=exited, status=0/SUCCESS)

Jun 01 17:51:40 portfolio systemd[1]: Starting LSB: start and stop MySQL... Jun 01 17:51:40 portfolio mysql.server[994]: /etc/init.d/mysql.server: 1: my_print_defaults: …found Jun 01 17:51:40 portfolio mysql.server[968]: Starting MySQL Jun 01 17:51:40 portfolio mysql.server[968]: * Couldn't find MySQL server (/usr/local/mysql/…safe) Jun 01 17:51:40 portfolio systemd[1]: Started LSB: start and stop MySQL. Hint: Some lines were ellipsized, use -l to show in full.

username@server:~$ mysql -u root -p

Command 'mysql' not found, but can be installed with:

sudo apt install mysql-client-core-8.0 # version 8.0.29-0ubuntu0.20.04.3, or sudo apt install mariadb-client-core-10.3 # version 1:10.3.34-0ubuntu0.20.04.1

username@server:~ $ sudo bin/mysqld_safe --user=mysql & [1] 1734 username>@server:~ $ sudo: bin/mysqld_safe: command not found

Can someone help me to resolve this?

I got same issue. I have an app that vendor still using MySQL 5.6 Deprecated and it has been very difficult to install 5.6 on Debian 10 or Ubuntu 18. I made it work on Deb 9, but then php only gets to 7.0.

Might have to also install libnuma-dev, libmysqlclient-dev and also this https://askubuntu.com/a/1337909/464278

Thank you!

Thank you!

Thank you

thank you very much much <3

Thank you!

root@ubuntu:~# mysql -u root -p
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

apt-get install libncurses5
ldconfig

Solved to me. Thanks for sharing!

Worked for me on Ubuntu 20
Thank You

After installation data directory stays /usr/local/mysql/data
you can stop mysql and change location in my.cnf and copy the /usr/local/mysql/data to another location

thanks

…

On Sun, Sep 17, 2023 at 12:28 AM Vijay Muddu ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Worked for me on Ubuntu 20 Thank You — Reply to this email directly, view it on GitHub <https://gist.github.com/vinodpandey/1a4b5b8228f9a000ca236820185fc3bc#gistcomment-4694650> or unsubscribe <https://github.com/notifications/unsubscribe-auth/AVYDSOQF3YSJN2OPWRYTYN3X2XOTHBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFQKSXMYLMOVS2I5DSOVS2I3TBNVS3W5DIOJSWCZC7OBQXE5DJMNUXAYLOORPWCY3UNF3GS5DZVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVEYTANJTGIZTAMBRU52HE2LHM5SXFJTDOJSWC5DF> . You are receiving this email because you are subscribed to this thread. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .

And you, my friend, are true hero.

Worked nicely with adding apt-get install libnuma-dev also with MySQL 5.5. Many thanks!

This was bleeping great. Thank-you!

Muchas gracias, muy util

Tried it on Ubuntu 24.04 - it worked. THANK YOU!

Had to create symlink for the following as Ubuntu 24 renamed those packages.

sudo ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/x86_64-linux-gnu/libaio.so.1

sudo ln -s /lib/x86_64-linux-gnu/libtinfo.so.6 /lib/x86_64-linux-gnu/libtinfo.so.5

sudo ln -s /lib/x86_64-linux-gnu/libncurses.so.6 /lib/x86_64-linux-gnu/libncurses.so.5