I have Ubuntu 12.04 installed, I need to install mysql 5.1 in that. Following steps I performed:
Other things to be installed:
Run this command to install alien and other necessary packages if not installed:
sudo apt-get install alien dpkg-dev debhelper build-essential
If you have already MySql installed (higher version than 5.1) then uninstall. Extract "MySQL-5.1.73-1.glibc23.i386.rpm-bundle.tar" in same dir. And, Navigate to "MySQL-5.1.73-1.glibc23.i386.rpm-bundle"
Issue following command to convert Mysql-server rpm to deb:
sudo alien MySQL-server-5.1.73-1.glibc23.i386.rpm
Issue following command to convert Mysql-client rpm to deb:
sudo alien MySQL-client-5.1.73-1.glibc23.i386.rpm
Issue following command to install Mysql-server:
sudo dpkg -i mysql-server_5.1.73-2_i386.deb
Issue following command to install Mysql-client:
sudo dpkg -i mysql-client_5.1.73-2_i386.deb
After the installation I'm getting the following error:
mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
After installation mysql.sock file is missing also my.cnf file is also missing.
I had refered the site http://www.howtogeek.com/howto/ubuntu/install-an-rpm-package-on-ubuntu-linux/ for RPM package installation in ubuntu
I need to install a software that is compatable with Mysql 5.1, I had tried to install with MySQl 5.5 i got the following error com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1
Is there any other way that I can install MySQl 5.1 in Ubuntu 12.04?