Install MySQL 5.1 on Ubuntu 12.04

Question

unfortunately I'm not able to change this config on the server, so I have to set it off per connection. Looking into the docs I've encountered an url parameter called "connectionAttributes" but i cant get it to work.

here is the url my.host:3306/mydb?connectionAttributes=sql-mode:""

Solution

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.

Comments

[Ignacio Vazquez-Abrams]

"I want to install 5.1" What for? 5.5 does pretty much everything 5.1 does.

[emgee]

And if you don't want the latest greatest, why 12.04 as opposed to 10.04?

[Matthew Reid]

What about this technique OR Installing MySQL from a Standard Source Distribution

[mangoDrunk]

@IgnacioVazquez-Abrams I'm not able to migrate from 5.1 to 5.5 yet.

[mangoDrunk]

@emgee Why do I have to stay on an older OS just because of the version of database I want? 5.1 isn't that old.

[mangoDrunk]

@MatthewReid Thanks for the links, those are the instructions in INSTALL-BINARY that I had some issues with. I guess I'll have to try them again.

[emgee]

@mangoDrunk you're absolutely right, you can get MySQL 5.1 to work in the newer version of Ubuntu. But for simplicity's sake, I personally would use 10.04 anyway, as MySQL 5.1 is in the repositories, is a snap to maintain and 10.04 Server is an LTS version, supported by Canonical until 2015. Just my $.02

[mangoDrunk]

@emgee Good point, I guess I should start checking what software is supported in the newer version and see if I should update or not.