How reset MySQL 5.x server root password - Ubuntu 11.10

Earlier blog, explained about MySQL 5.x Server install. If you would like to reset root password of MySQL server, You can use this command

$ sudo dpkg-reconfigure mysql-server-5.1

Install MySQL 5.x on Ubuntu 11.10

Simple steps to install MySQL 5.x Relational Databases on Ubuntu 11.10

1. Make sure you're system package repositories up to date by executing/running following updates commands

$ sudo apt-get update
$ sudo apt-get upgrade --show-upgraded

2. Install MySQL 5.x Server by following command, it will install with dependencies and client libraries.

$ sudo apt-get install mysql-server

Executing this command, You will be promoted to set root password for MySQL server.

Once MySQL server installed, you can start/stop/restart service by these commands

$ sudo service mysql start
$ sudo service mysql stop
$ sudo service mysql restart

I hope you may install MySQL 5.x on you're server. Following to this topic, i'll explain about MySQL secure install and configuration.