Install MySQL on Ubuntu 8.10

1. Get MySQL server and client:

sudo apt-get install mysql-server mysql-client \
mysql-query-browser

2. Comment out bind-address 127.0.0.1 in my.cnf.
gksudo gedit /etc/mysql/my.cnf

3. set password for root:
mysqladmin -u root -p status
then enter the passwd. It still doesn't work.

4. Work around for mysql commands:
mysqladmin|mysqlshow|mysql -u root -p

Then enter the root password.