Installing My-Sql in Ubuntu 9.10

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.