How can we create a new database by using mysqladmin?

MySQLMySQLi Database

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.

Published on 21-Feb-2018 06:21:00