Can I Use PDO to Create Databases in PHP?

Creating Databases with PDO in PHP

In PHP, PDO (PHP Data Objects) is a widely used extension for interacting with databases. One of its capabilities is the creation of MySQL databases.

Solution

Yes, you can create new MySQL tables using PDO. To do so, you can utilize the PDO constructor without specifying a database name in the dsn parameter (typically mysql:host=localhost). This allows you to perform database-related operations, such as database creation, through SQL commands.

Example usage

The following PHP code demonstrates how you can create a database, a user, and grant privileges utilizzando PDO:

<?php

    $host = &quot;localhost&quot;;

    $root = &quot;root&quot;;
    $root_password = &quot;rootpass&quot;;

    $user = 'newuser';
    $pass = 'newpass';
    $db = &quot;newdb&quot;;

    try {
        $dbh = new PDO(&quot;mysql:host=$host&quot;, $root, $root_password);

        $dbh->exec(&quot;CREATE DATABASE `$db`;
                CREATE USER '$user'@'localhost' IDENTIFIED BY '$pass';
                GRANT ALL ON `$db`.* TO '$user'@'localhost';
                FLUSH PRIVILEGES;&quot;)
        or die(print_r($dbh->errorInfo(), true));

    }
    catch (PDOException $e) {
        die(&quot;DB ERROR: &quot; . $e->getMessage());
    }
?>

In this example:

• The PHP script connects to MySQL using root credentials.
• It creates a new database named newdb.
• A new user newuser is created with password newpass and granted access to the new database.
• The script flushes privileges to make changes effective.

The above is the detailed content of Can I Use PDO to Create Databases in PHP?. For more information, please follow other related articles on the PHP Chinese website!