Install MySQL 5.5 on Ubuntu 10.04

Question

How to install the MySQL 5.5 on Ubuntu 10.04?

apt-get install mysql-server is only allows to install 5.1.41.3ubuntu12

Answer 1

Unless you have some specific problems with your environment or installation procedure, it follows the normal pattern:

• you should obtain the generic binary .tar.gz package from MySql's download page
• then follow the binary installation instructions

Answer 2

I used The following guide to install 5.5 on Ubuntu 10.04: http://www.ovaistariq.net/490/a-step-by-step-guide-to-upgrading-to-mysql-5-5/

Everything worked perfectly except one of the final steps, launching mysql:

mysqld --skip-grant-tables --user=mysql

Was giving me the following message and then shutting down:

[ERROR] Can't find messagefile '/usr/share/errmsg.sys'

After some googling I found the solution to be adding the following flag:

--lc-messages-dir="/usr/local/mysql/share/english/"

To launch it and have it actually work, I used the following command:

 mysqld --skip-grant-tables --user=mysql --lc-messages-dir="/usr/local/mysql/share/english/"

MySQL 5.5 has some great new features that solved a partitioning issue for me; partitioning via a varchar.

Good luck!

Answer 3

simple instructions for installation of MySQL 5.5 on Linux are documented here along with other libraries that are required.

http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/download_configure_compile_and_install_mysql_558_on_linux.php

Answer 4

There are so many missteps in the earlier blog. I found a poorly formatted one but the steps worked for me.

http://greensysadmin.com/2011/01/24/mysql-5-5-installing-from-source-ubuntu-debian/

Answer 5

I have written an article on how to install MySQL 5.5 on Ubuntu 10.10 using Ubuntu packages, I'm pretty sure it will work without any major issues on 10.04: http://geek.co.il/wp/2011/03/02/mysql-5-5-on-ubuntu-10-10

Answer 6

add-apt-repository ppa:internetbroadcasting/mysql55onlucid
apt-get install mysql-server-5.5

Users with local apache+php5+mysql or similar combination with mysql in it would likely need to recompile mysql-dependent packages (php5-mysql), so it uses libmysqlclient18 provided by mysql-server-5.5.

Using libmysqlclient16-linked packages with mysql 5.5 installation might appear to be working initially, but would tend to crash randomly.