mysql 5.5 in Debian

groupadd mysql
useradd mysql -s /bin/bash -m /var/mysql -g mysql
chown -R mysql.mysql /var/mysql/data

apt-get install cmake gcc g++ automake

tar -zxvf mysql-5.5.24.tar.gz

cd mysql-5.5.24/

cmake . -DMYSQL_DATADIR=/var/mysql/data -DCMAKE_INSTALL_PREFIX=/usr/local/ -DINSTALL_LAYOUT=STANDALONE -DENABLED_PROFILING=ON -DMYSQL_MAINTAINER_MODE=OFF -DWITH_DEBUG=OFF

make && make install
chmod +x scripts/mysql_install_db.sh
scripts/mysql_install_db.sh –user=mysql –basedir=/usr/local/ –datadir=/var/mysql/data/
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
/etc/init.d/mysqld start

Now you are done.

mysql will be listening on port 3306

# mysql -u root