Install MySQL and create Database in ubuntu Karmic Koala (9.10)

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to several databases. in ubuntu, you can create database from mysql but before create database you can install this packages, to install it follow this step :



Go to terminal and login as root by type :

$ sudo su
$ apt-get install apache2

Now install MySQL by type :

$ apt-get install mysql-server

Install php for Apache web server by type : 

$ apt-get install php5 

Then Install MySQL for Apache by type :

$ apt-get install php5-mysql

Dont forget type root password for mysql, after installation finished, restart mysql by type:

$ sudo /etc/init.d/mysql start

Create Database

Now you can create database or table database by using terminal and type :

$ mysql -u root -p

Create database by type :

$ create database database_test;

To using and editing your database, you can use this command :

$ use database_test;

Happy Testing.....!!
Read More...!!