HostOnNet Blog

Creating MySQL Database

Looking for Linux Server Admin or WordPress Expert? We can help.

You can create MySQL database with create database DATABASE_NAME command.

root@host [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 937316 to server version: 4.0.25-standard

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.

mysql> create database bizhat;
Query OK, 1 row affected (0.01 sec)

mysql>

To delete a MySQL Database, use drop database command.

mysql> drop database bizhat;
Query OK, 0 rows affected (0.00 sec)

mysql>

Posted in Database. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.