What permissions or rights are required for a user account to create a database using PHP and MySQL?

To create a database using PHP and MySQL, the user account must have the necessary permissions to create databases. Typically, the user account needs the "CREATE" privilege to create databases. This privilege can be granted by the database administrator. 

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create database
$sql = "CREATE DATABASE myDB";
if ($conn->query($sql) === TRUE) {
    echo "Database created successfully";
} else {
    echo "Error creating database: " . $conn->error;
}

$conn->close();
?>

Keywords

PHP MySQL permissions user account database creation

Related Questions