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 −

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

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.

raja
Updated on 20-Jun-2020 13:40:02

Advertisements