MySQL creates a database in two ways: mysql creates a database in two ways

MySQL creates a database in two ways: mysql creates a database in two ways

This article shares two methods for creating a MySQL database for your reference. The specific content is as follows:

Method 1:Use mysqladmin to create a database
For normal users, you may need specific permissions to create or delete MySQL databases.

Therefore, we use the root user to log on. the root user has the highest permissions and can use the mysql mysqladmin command to create a database.

Instance

The following command demonstrates the process of creating a database. The data name is TUTORIALS:

[Root @ host] # mysqladmin-u root-p create TUTORIALS
Enter password :******
After the preceding command is successfully executed, the MySQL database TUTORIALS is created.

Method 2:Use a PHP script to create a database
PHP uses the mysql_query function to create or delete a MySQL database.

This function has two parameters. TRUE is returned when execution is successful. Otherwise, FALSE is returned.

Syntax: bool mysql_query (SQL, connection );

Instance

The following example demonstrates how to create a database using PHP:

The above two methods are used to create databases in MySQL. I hope they will be helpful for your learning, and I hope you can provide more support to the customer center.