wget http://sunsite.informatik.rwth-aachen.de/mysql/Downloads/MySQL-4.1/mysql-4.1.22.tar.gz

tar xvzf mysql-4.1.22.tar.gz

cd mysql-4.1.22

useradd -d "/usr/local/mysql41" -c "MySQL41 Daemon User" -s "/bin/false" -g "mysql" -m mysql41

apt-get install make g++ gcc automake libncurses5-dev rcconf

./configure --prefix=/usr/local/mysql41 --with-unix-socket-path=/usr/local/mysql41/var/mysqld.sock --with-mysqld-user=mysql41 --with-server-suffix=mysql41 --with-tcp-port=3308

make && make install

/usr/local/mysql41/bin/mysql_install_db

chown -R mysql41:mysql /usr/local/mysql41

cp /usr/local/mysql41/share/mysql/mysql.server /etc/init.d/mysql41

cp /usr/local/mysql41/share/mysql/my-medium.cnf /usr/local/mysql41/var/my.cnf

cd /usr/local/mysql41/var

/etc/init.d/mysql41 start

/usr/local/mysql41/bin/mysql --user root

mysql> update mysql.user set Password=PASSWORD('biscuit') where User='root';

//etc/init.d/mysql41 stop

/etc/init.d/mysql41 start

rcconf (mysql41 in Autostart aufnehmen)

In die DB einsteigen (mit root und passwort)

GRANT ALL PRIVILEGES ON *.* TO 'CAO_DB'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

update mysql.user set password=old_password('password') where user='CAO_USER' and host='%';

FLUSH PRIVILEGES;

create database CAO_DB;

Aus DB aussteigen

/usr/local/mysql41/bin/mysql --user root --password CAO_DB < cao_db.sql;