Install MySQL 5.5 on Ubuntu 10.04
Solution 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.gzpackage from MySql's download page - then follow the binary installation instructions
Solution 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!
Solution 3:
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.