After logging into the MySQL service, we can use the
create
Command to create the database, the syntax is as follows:
CREATE DATABASE 数据库名;
The following command simply demonstrates the process of creating a database, named RUNOOB:
[root@host]# mysql -u root -p
Enter password:****** # 登录后进入终端
mysql> create DATABASE RUNOOB;
Create a database using mysqladmin ¶
With normal users, you may need specific permissions to create or delete MySQL databases.
So we use the root user to log in, and the root user has the highest privileges, so we can use the mysql mysqladmin command to create the database.
The following command simply demonstrates the process of creating a database, named RUNOOB:
[root@host]# mysqladmin -u root -p create RUNOOB
Enter password:******
The MySQL database RUNOOB is created after the above command is executed successfully. PHP usage This function takes two arguments and returns on successful execution. Create a database using a PHP script ¶
mysqli_query
Function to create or delete an MySQL database.
TRUE
Otherwise, return
FALSE
.
Grammar ¶
mysqli_query(connection,query,resultmode);
Parameters. | Description |
|---|---|
connection | Necessary. Specifies the MySQL connection to be used. |
query | Required, specify the query string. |
resultmode | Optional. A constant. It can be any of the following values:
|
Example ¶
The following example demonstrates using PHP to create a database:
Create a database
<?php$dbhost='localhost';//mysql服务器主机地址$dbuser='root';//mysql用户名$dbpass='123456';//mysql用户名密码$conn=mysqli_connect($dbhost,$dbuser,$dbpass);if(!$conn){die('连接错误:'.mysqli_error($conn));}echo'连接成功<br
/>';$sql='CREATE DATABASE
RUNOOB';$retval=mysqli_query($conn,$sql);if(!$retval){die('创建数据库失败:'.mysqli_error($conn));}echo"数据库
RUNOOB 创建成功\\n";mysqli_close($conn);?>
When the execution is successful, the following result is returned:
If the database already exists, the following result is returned after execution:
