PHP MySQL Create Database

A database is a container for storing and managing data.

What permissions are required to create a database?

Before creating a database, make sure you have the CREATE privilege.

Creating a Database using MySQLi and PDO

The CREATE DATABASE statement is used to create a database in MySQL.

Example (MySQLi - Object-Oriented)

<?php\n$servername = "localhost";\n$username = "username";\n$password = "password";\n\n// Create connection\n$conn = new mysqli($servername, $username, $password);\n// Check connection\nif ($conn->connect_error) {\n    die("Connection failed: " . $conn->connect_error);\n} \n\n// Create Database\n$sql = "CREATE DATABASE myDB";\nif ($conn->query($sql) === TRUE) {\n    echo "Database created successfully";\n} else {\n    echo "Error creating database: " . $conn->error;\n}\n\n$conn->close();\n?>

Example (MySQLi - Procedural)

<?php\n$servername = "localhost";\n$username = "username";\n$password = "password";\n\n// Create connection\n$conn = mysqli_connect($servername, $username, $password);\n// Check connection\nif (!$conn) {\n    die("Connection failed: " . mysqli_connect_error());\n}\n\n// Create Database\n$sql = "CREATE DATABASE myDB";\nif (mysqli_query($conn, $sql)) {\n    echo "Database created successfully";\n} else {\n    echo "Error creating database: " . mysqli_error($conn);\n}\n\nmysqli_close($conn);\n?>

Example (PDO)

<?php\n$servername = "localhost";\n$username = "username";\n$password = "password";\n\ntry {\n    $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);\n    // Set PDO error mode to exception\n    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n    $sql = "CREATE DATABASE myDB";\n    // Use exec() ，Because no results are returned\n    $conn->exec($sql);\n    echo "Database created successfully<br>";\n    }\ncatch(PDOException $e)\n    {\n    echo $sql . "<br>" . $e->getMessage();\n    }\n\n$conn = null;\n?>