How does MySQL create a database?Create MySQL database command/statement/syntax

MySQLHow to create a database?createMySQL databaseCommand/Statement/Syntax

MySQL create database

Create a database using mysqladmin

With a normal user, you may need specific privileges to create or delete MySQL databases.

So we use the root user to log in here. The root user has the highest authority and can use the mysql mysqladmin command to create a database.

Examples

The following command simply demonstrates the process of creating a database named chenweiliang:

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

After the above command is executed successfully, the MySQL database chenweiliang will be created.

Create database using PHP script

PHP uses the mysqli_query function to create or delete MySQL databases.

The function has two parameters and returns TRUE if the execution is successful, otherwise it returns FALSE.

grammar

mysqli_query(connection,query,resultmode);

Examples

The following example demonstrates the use of PHP to create a database:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接错误: ' . mysqli_error($conn));
}
echo '连接成功
';
$sql = 'CREATE DATABASE chenweiliang';
$retval = mysqli_query($conn,$sql );
if(! $retval )
{
 die('创建数据库失败: ' . mysqli_error($conn));
}
echo "数据库 chenweiliang 创建成功\n";
mysqli_close($conn);
?>

After successful execution, the following results are returned:

connection succeeded

The database chenweiliang was created successfully