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
Published on 21-Feb-2018 06:21:00
Advertisements