Create a simple tutorial for creating a MySQL database

Create a simple tutorial for creating a MySQL database

Use mysqladmin to create a database:

Special permissions are required to create or delete a MySQL database. Therefore, if you access the database as a root user, you can create any database using the mysql mysqladmin binary.
Example:

Here is a simple example to create a database named TUTORIALS:

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

This creates a database: TUTORIALS.
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. If TRUE is returned, success or failure is returned, FALSE is returned.
Syntax:

bool mysql_query( sql, connection );

Example:

Try the following example to create a database: