Ubuntu – Install MySQL 5.5 on Ubuntu 10.04

Ubuntu 10.04 has abandoned SysV init script approach to booting the system.

This link explains - http://www.linuxplanet.com/linuxplanet/tutorials/7033/1/

To prevent mysql from starting on boot

• 1 go to the /etc/init directory
• 2. open the mysql.conf file
• 3. comment out the "start on" line near the top of the file, the "start on" might be spread across two lines, so comment out both

If you want to manually start mysql, use the following command -

  service mysql start

The solution I ended up using was MySQL Sandbox. With MySQL Sandbox, I was able to install MySQL 5.1 self-contained in one folder which is better in my opinion than having MySQL using many different folders which is harder to uninstall which may have been the reason for issues with installing 5.1 manually after having installed 5.5. With MySQL Sandbox, I'm able to have multiple instances of MySQL installed without them conflicting with one another.