HOWTO : Regenerate SSL certificate and Reset MySQL root password on Ubuntu 9.04

When your SSL certificate is expired or need to regenerate for some reason, you can issue the following command under Ubuntu 9.04.

sudo make-ssl-cert generate -default-snakeoil --force-overwrite

When you forgot the root password of MySQL, you can reset it by issue the following command under Ubuntu 9.04.

sudo dpkg-reconfigure mysql-server-5.0