How do we create a new database using mysqladmin?

We need special permissions to create or delete MySQL databases. Following is the syntax to create a new database using the mysqladmin binary -

Syntax

[root@host]# mysqladmin -u root -p create db_name
Enter password:******

Here, db_name is the name of the database we want to create.

Example

The following is a tutorial to create a database named <的数据库的简单示例强>−

[root@host]# mysqladmin -u root -p create TUTORIALS
Enter password:******

The above query will create a MySQL database named TUTORIALS.

The above is the detailed content of How do we create a new database using mysqladmin?. For more information, please follow other related articles on the PHP Chinese website!