How to create a MySQL Database in Linux ?

How to create a MySQL Database in Linux?

First login to your mysql server with your root credential

# mysql -u root –p

 Enter password:      (now type your root passwort)

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 705

Server version: 5.1.25-rc-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Now create database testdb1

mysql> create database testdb1;

Now show all databases.

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| test           |

| testdb1             |

+--------------------+

4 rows in set (0.00 sec)