We would need special privileges to create or to delete a MySQL database. Following is the syntax for creating a new database using mysqladmin binary −
[root@host]# mysqladmin -u root -p create db_name Enter password:******
Here, db_name is the name of the database we want to create.
Following is a simple example to create a database called TUTORIALS −
[root@host]# mysqladmin -u root -p create TUTORIALS Enter password:******
The above query will create a MySQL database called TUTORIALS.