Wednesday, October 04, 2006

Installing MySql (mysql)

# wget http://downloads.mysql.com/archives/mysql-4.0/MySQL-client-4.0.12-0.i386.rpm
# wget http://downloads.mysql.com/archives/mysql-4.0/MySQL-devel-4.0.12-0.i386.rpm
# wget http://downloads.mysql.com/archives/mysql-4.0/MySQL-shared-4.0.12-0.i386.rpm
# wget http://downloads.mysql.com/archives/mysql-4.0/mysql-standard-4.0.12-pc-linux-i686.tar.gz
# rpm --install *.rpm

#mysql

this should connect you to mysql.. incase you have error.. mostly the following error might be generated..

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

to solve this.. do the following..

First, copy a configuration file, in somewhere like 'support files', choose 'my-medium.cnf' or 'my-large.cnf' .... and paste it in /etc/my.cnf, yes change the name to 'my.cnf'.

In that file you can change the path to the socket file, 'Socket = /path/to/socket'.Another thing I did is make a empty 'mysql.sock' file and place it in the 'path/to/socket(you can also copy it somewhere from the installation package).

and then

#mysql