Debian Lenny – Installing MySQL

sudo aptitude install mysql-server mysql-client libmysqlclient15-dev

sudo gem install mysql

mysql -u root -p
CREATE DATABASE my_table;
INSERT INTO mysql.user (User,Host,Password) VALUES(‘my_user’,’localhost’,PASSWORD(‘mypassword’));
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON my_table.* to my_user@localhost;
FLUSH PRIVILEGES;
SHOW GRANTS FOR ‘my_user’@’localhost’;

http://articles.slicehost.com/2011/3/10/installing-mysql-server-on-debian