Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Install MySQL 5.5.xx on Ubuntu
@Mqleaf
Copy link

Mqleaf commented Sep 28, 2019

Can it work for MySQL 5.6 on Ubuntu 18.04? @ahmadhasankhan

@derisrayan
Copy link

derisrayan commented Oct 10, 2019

Thank you Sir Ahmad (y)

@Nditah
Copy link

Nditah commented Nov 11, 2019

Please correct step 9

sudo mv mysql-5.5.56-linux-glibc2.5-x86_64 mysql

@jasepulveda
Copy link

jasepulveda commented Nov 25, 2019

excellent, thanks !!

Copy link

ghost commented Nov 25, 2019

can this be used for mysql 5.6 as well?

support-files/my-medium.cnf will be support-files/my-default.cnf

Copy link

ghost commented Nov 26, 2019

I can see that MySQL is up and running:

CGroup: /system.slice/mysql.server.service ├─732 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/loca…id └─939 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --dat…id

But, Command 'mysqld' not found

Can you advise on this? @ahmadhasankhan

@petrich
Copy link

petrich commented Jan 18, 2020

Great. Saved the day 👍

@docdeveloper
Copy link

docdeveloper commented Jan 23, 2020

Thank you. These instructions got me what I needed.

@KevinBerthier
Copy link

KevinBerthier commented Mar 10, 2020

Thanks ! A lot !

@marcoschadu
Copy link

marcoschadu commented Mar 11, 2020

I need the mysql 5.5 and in fact I managed to install it on Debian 10 and Ubuntu 18. However in both OS webmin (wich I unfortunately need) shows the myqsl correctly (5.5xxx) BUT as mariaDB database... Why is it? I didn't install mariaDB, just followed the steps describes above. Anyone could help me please? This happens with all debian and ubuntu versions, except Debian 8 and ubuntu 14 server, but both are pretty obsolete...

@le-yo
Copy link

le-yo commented Apr 5, 2020

Thanks A lot

@nor5
Copy link

nor5 commented Apr 8, 2020

I installed on ubuntu 18 and it works, thank you so match

@Malkom
Copy link

Malkom commented Jul 15, 2020

Thanks man, you save my day !!!

@steffres
Copy link

steffres commented Jul 28, 2020

Thank you so very much!! You helped me immensely in getting a legacy mysql db running on UbuntuServer 20.04

A few small remarks however:

Is apt-get remove apparmor really necessary? In my case when I wanted to run it, apt said it would remove apparmor snapd and snapd seemed a bit too system-relevant to me, given how much Ubuntu now pushes towards snaps. Anyway, so I left it out and it worked fine as well.

And a little nitpicking perhaps, but for the sake of consistency with all the other very verbose steps, I suggest to also include the cd command in the step "Set mysql directory owner from outside the mysql directory" like:

cd ..
chown -R root .

and in the next one then:

cd mysql
chown -R mysql data

Again, excellent work and thank you!

Cheers!

@acosonic
Copy link

acosonic commented Jul 30, 2020

Here is my askubuntu answer for mysql 5.7 done in a similar way...

https://askubuntu.com/a/1263423/513874

@chppppp
Copy link

chppppp commented Jul 31, 2020

I am trying to perform this with mysql 5.5.47 on Debian 8 and i get this error. any suggestions? thanks!

$ sudo scripts/mysql_install_db.sh --user=mysql

FATAL ERROR: Could not find @bindir@/my_print_defaults

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

@ahmadhasankhan
Copy link
Author

ahmadhasankhan commented Aug 3, 2020

I am trying to perform this with mysql 5.5.47 on Debian 8 and i get this error. any suggestions? thanks!

$ sudo scripts/mysql_install_db.sh --user=mysql

FATAL ERROR: Could not find @bindir@/my_print_defaults

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

Search the packages for my_print_defaults using

find / -name my_print_defaults

Check if my_print_defaults is missing on your system (which my_print_defaults), first find out which db is installed with:

dpkg -l |grep -E 'maria|mysql'|grep ii|grep server

@andreguipeil
Copy link

andreguipeil commented Aug 7, 2020

Thank out man! It's works perfectly!

@felipebutcher
Copy link

felipebutcher commented Aug 8, 2020

28 comments and no error. I think you are an angel fallen from sky.

@prashantnirgun
Copy link

prashantnirgun commented Aug 30, 2020

I have ubuntu 20 64 Bit I am getting error
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

can anyone help me please

I am using
uname -a
Linux lappy-b50-80 5.4.0-42-generic #46-Ubuntu SMP Fri Jul 10 00:24:02 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

@ehsanatwork
Copy link

ehsanatwork commented Sep 28, 2020

hello
thank you for your nice tutorial.
and it up and running.
but why it is showing the following error when i an giving the commang mysql --version

here is the error
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

@leoneDuarte
Copy link

leoneDuarte commented Sep 30, 2020

Ola esse Funcionou para min

Se der esse erro:
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

Esse comando resolve
apt-get install libncurses5

@madindo
Copy link

madindo commented Nov 5, 2020

got this working on ubuntu 20.04... you're my hero

@avi7611
Copy link

avi7611 commented Nov 10, 2020

which mysql-client version i need to install with this ?

@JTorres87
Copy link

JTorres87 commented Dec 16, 2020

If anyone runs in to the error
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
Simply install libncurses5
sudo add-apt-repository universe
sudo apt-get install libncurses5

You sir are a life saver and have made our lives easier. Thank You

@jascadev
Copy link

jascadev commented Jan 20, 2021

Thank you very much for these instructions!

@mostafijurr
Copy link

mostafijurr commented Jul 1, 2021

While I am trying to log in using root user, but it shows these errors.
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

@acosonic
Copy link

acosonic commented Jul 1, 2021

While I am trying to log in using root user, but it shows these errors.
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

@mostafijurr have you tried answer of @JTorres87 ? Take a look at second comment above yours.

@mostafijurr
Copy link

mostafijurr commented Jul 2, 2021

@acosonic I have tried with this. but it is not working. its shows errors.
image

@acosonic
Copy link

acosonic commented Jul 2, 2021

@acosonic I have tried with this. but it is not working. its shows errors.
image

This would now be a different problem... What happens if you sudo su, then mysql -u root ... ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment