Install MySQL 5.5 on Ubuntu 10.04

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

Mithun Sreedharan

Posted 2010-05-28T13:12:42.213

Reputation: 1 485

Answers

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

Jawa

Posted 2010-05-28T13:12:42.213

Reputation: 3 349

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!

Jay Taylor

Posted 2010-05-28T13:12:42.213

Reputation: 183

I was able to follow the instruction guide without any error. The only thing is at step "Start MySQL server without grants table." it looks like it hangs but it doesn't. Just open another terminal and continue the steps in that new terminal. – iDev247 – 2013-02-05T20:06:53.573

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.

Arie Skliarouk

Posted 2010-05-28T13:12:42.213

Reputation: 178

Due to dependencies, I needed to run: apt-get install mysql-server-5.5 mysql-server-core-5.5 mysql-client-5.5 – jdhildeb – 2014-07-10T18:54:13.480

Don't forget to run sudo apt-get update – Hengjie – 2014-06-14T15:13:34.233

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

shahryar

Posted 2010-05-28T13:12:42.213

Reputation: 11

Please summarize the steps here, rather than only plugging your own blog? – Arjan – 2010-12-21T15:58:26.900

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

Guss

Posted 2010-05-28T13:12:42.213

Reputation: 583