How to install Mysql 4 on Ubuntu 8.04

Download and install mysql 4.1 server and client from debian packages

Then Stop mysql service (if running)

Create the directory  /var/run/mysqld and change the ownership to mysql user

$ mkdir /var/run/mysqld
$ chown -R mysql:mysql /var/run/mysqld/
 

Edit my.cnf and mysql_config(if installed) and change the socket value

$ vi /etc/my.cnf
    change socket to /var/run/mysqld/mysqld.sock
$ vi /usr/local/mysql/bin/mysql_config
    change socket to /var/run/mysqld/mysqld.sock

Start mysql service.