Learn how to create a MySQL Database

By admin|Computer, MySQL

You can use mysqladmin create command to create a mysql database.

# mysqladmin -u root -ptmppassword create mydb

# mysql -u root -ptmppassword
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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| sugarcrm           |
| mydb               |
+--------------------+
4 rows in set (0.00 sec)