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: