Install MySQL 5.5.xx on Ubuntu

MySql-5.5-installation guide.md

Please visit https://asistencia.in/blogs/1-mysql-5-5-installation-guide

Thank you

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

Thank you Sir Ahmad (y)

Please correct step 9

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

excellent, thanks !!

can this be used for mysql 5.6 as well?

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

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

Great. Saved the day 👍

Thank you. These instructions got me what I needed.

Thanks ! A lot !

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

Thanks A lot

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

Thanks man, you save my day !!!

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!

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

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

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.

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

Thank out man! It's works perfectly!

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

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

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

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

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

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

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

Thank you very much for these instructions!

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

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.

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

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

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