How to create a database with MySQL

Spoke Right / 10 Nov, 2023

PHP uses mysqli query() or mysql_query() function to create or delete a MySQL database. This function takes two parameters and returns TRUE on success or FALSE on failure.

Syntax

$mysqli->query($sql,$resultmode)

Example

Try the following example to create a database −

Copy and paste the following example as mysql_example.php −

Creating MySQL Database

connect_errno ) { printf("Connect failed: %s
", $mysqli->connect_error); exit(); } printf('Connected successfully.
'); if ($mysqli->query("CREATE DATABASE TUTORIALS")) { printf("Database TUTORIALS created successfully.
"); } if ($mysqli->errno) { printf("Could not create database: %s
", $mysqli->error); } $mysqli->close(); ?>

Output

Access the mysql_example.php deployed on apache web server and verify the output.

Connected successfully.
Database TUTORIALS created successfully.