vinodpandey/MySql-5.6-installation guide.md

Last active March 31, 2025 14:29

Star (45) You must be signed in to star a gist
Fork (35) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/vinodpandey/1a4b5b8228f9a000ca236820185fc3bc.js"></script>
Save vinodpandey/1a4b5b8228f9a000ca236820185fc3bc to your computer and use it in GitHub Desktop.

Download ZIP

Install MySQL 5.6.xx on Ubuntu 18.04 & Ubuntu 20.04

Raw

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

ragazzid commented Nov 17, 2021

Thank you for this!

dominickasanga commented Feb 28, 2022

Very helpful, thank you!

EmmanuelChangole commented Mar 11, 2022

this helped me, thank you

NeeONCorp commented Mar 16, 2022

Many thanks! This worked for me 👍

socheatkd commented Apr 25, 2022

thank you so much. this work for me

anbuarivu commented Jun 2, 2022

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?

Rod01Andres commented Jun 22, 2022

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

wakko4 commented Oct 22, 2022

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.

jlurena commented Dec 11, 2022 •

edited

Loading

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

setaniel commented Dec 21, 2022

Thank you!

Juanvcas commented Dec 23, 2022

Thank you!

aboooud commented Mar 29, 2023

Thank you

havanri commented May 10, 2023

thank you very much much <3

MartinGuerraGit commented May 15, 2023

Thank you!

tbernacchi commented Aug 15, 2023

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

tbernacchi commented Aug 15, 2023

apt-get install libncurses5
ldconfig

Solved to me. Thanks for sharing!

vijaymuddu commented Sep 16, 2023 •

edited

Loading

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

kh-168 commented Sep 19, 2023 via email

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

CNZedChou commented Sep 23, 2023

And you, my friend, are true hero.

nVentis commented Jan 22, 2024 •

edited

Loading

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

AdamMichaelArthur commented Jan 30, 2024

This was bleeping great. Thank-you!

Jiculi commented Mar 25, 2024

Muchas gracias, muy util

kani commented Nov 27, 2024

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

ankovalchuk commented Mar 31, 2025

Thank you very much!!! It's really working! Very good. Wish health to you kind man!

vinodpandey/MySql-5.6-installation guide.md

Open the terminal and follow along:

ragazzid commented Nov 17, 2021

dominickasanga commented Feb 28, 2022

EmmanuelChangole commented Mar 11, 2022

NeeONCorp commented Mar 16, 2022

socheatkd commented Apr 25, 2022

anbuarivu commented Jun 2, 2022

Rod01Andres commented Jun 22, 2022

wakko4 commented Oct 22, 2022

jlurena commented Dec 11, 2022 • edited Loading

setaniel commented Dec 21, 2022

Juanvcas commented Dec 23, 2022

aboooud commented Mar 29, 2023

havanri commented May 10, 2023

MartinGuerraGit commented May 15, 2023

tbernacchi commented Aug 15, 2023

tbernacchi commented Aug 15, 2023

vijaymuddu commented Sep 16, 2023 • edited Loading

kh-168 commented Sep 19, 2023 via email

CNZedChou commented Sep 23, 2023

nVentis commented Jan 22, 2024 • edited Loading

AdamMichaelArthur commented Jan 30, 2024

Jiculi commented Mar 25, 2024

kani commented Nov 27, 2024

ankovalchuk commented Mar 31, 2025

jlurena commented Dec 11, 2022 •

edited

Loading

vijaymuddu commented Sep 16, 2023 •

edited

Loading

nVentis commented Jan 22, 2024 •

edited

Loading