Installing MySQL in Ubuntu 9.10

As I begin to import my project into Ubuntu 9.10, I had to install MySQL too. Just at that time I realise, why don’t I publish this instruction for you all. At least, it will help some body. I hope you will be among that somebody.

For Installation and use MySQL you have to give some instruction in terminal:

Step 1:

sudo apt-get install mysql-server

This will install the latest MySQL-server into your machine.

Step 2:

sudo /etc/init.d/mysql start

Which will start the MySQL server.

Step 3:

mysql -u root -p

This instruction will ask you the MySql server that you have entered during installation.

Step 4:

create database db_test

This instruction will create a new database “db_test”

Step 5:

use db_test

which will let you inside the database.

Now use MySQL Query to work with it n Enjoy.