How to install MySQL 5.5 on Ubuntu

-
I have been beating my head against the wall for almost a year now, trying to figure out how to install MySQL 5.5 on Ubuntu since there is still not a .deb package to use. OpenDental software makes use of MySQL as it's database and since my servers have always run Ubuntu, I didn't really want to switch to an RPM based distro and have to learn new tricks for that system just for this reason. MySQL 5.1 was giving off and on errors and the time had come that I to either get it to work or ditch Ubuntu for and RPM based distro (probably OpenSuse/Fedora/Mandriva).

Finally, after trying it seems like twenty or thirty tutorials on the net and having problem at one point or another with all of them, I succeeded and got MySQL 5.5.14 running on Ubuntu 11.04 "lucid!"

If you follow the steps below from a standard Ubuntu/MySQL LAMP server install, you should be able to have a working v5.5 server in no time!

(help from this thread: https://code.launchpad.net/~clint-fewbar/ubuntu/natty/mysql-5.1/mysql-5.5-packaging)

64bit Machine w/ MySQL 5.5.14

sudo apt-get purge mysql-server
sudo apt-get purge mysql-client
sudo apt-get purge mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo rm -fr /var/lib/mysql

sudo wget -O MySQL-server-5.5.14-1.linux2.6.x86_64.rpm http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.14-1.linux2.6.x86_64.rpm/from/http://mysql.mirrors.hoobly.com/

 

sudo wget -O MySQL-client-5.5.14-1.linux2.6.x86_64.rpm http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.14-1.linux2.6.x86_64.rpm/from/http://mysql.mirrors.hoobly.com/

 

sudo apt-get install alien

sudo alien -i MySQL-server-5.5.14-1.linux2.6.x86_64.rpm --scripts

sudo alien -i MySQL-client-5.5.14-1.linux2.6.x86_64.rpm --scripts

 

sudo apt-get install libaio1 libaio-dev
sudo /usr/sbin/mysqld --skip-grant &
sudo /etc/init.d/mysql start

If you want to secure the installation and put a password on the root user:

/usr/bin/mysql_secure_installation

​​

Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more