Can I create a database using PDO in PHP?

by

Yes, you can.

The dsn part, which is the first parameter of the PDO constructor, does not have to have a database name. You can simply use mysql:host=localhost. Then, given you have the right privilege, you can use regular SQL commands to create a database and users, etc.

Following is an example from an install.php file. It logs in with root, create a database, a user, and grant the user all privilege to the new created database:

<?php

    $host = "localhost";

    $root = "root";
    $root_password = "rootpass";

    $user="newuser";
    $pass="newpass";
    $db = "newdb";

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

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

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

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Getting raw SQL query string from PDO prepared statements
  5. How do I set ORDER BY params using prepared PDO statement?
  6. “Invalid parameter number: parameter was not defined” Inserting data
  7. Having issue with matching rows in the database using PDO
  8. How can I properly use a PDO object for a parameterized SELECT query
  9. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  10. PDO with INSERT INTO through prepared statements [closed]
  11. PDO::fetchAll vs. PDO::fetch in a loop
  12. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  13. Real escape string and PDO [duplicate]
  14. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  15. PDO Connection Test
  16. PHP PDO vs normal mysql_connect
  17. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  18. PDO::PARAM for type decimal?
  19. PHP PDO and MySQLi [duplicate]
  20. PDO fetch one column from table into 1-dimensional array
  21. Update query with PDO and MySQL
  22. Is “SET CHARACTER SET utf8” necessary?
  23. Getting a PHP PDO connection from a mysql_connect()?
  24. Having issue with matching rows in the database
  25. Set PDO to throw exceptions by default [duplicate]
  26. PDO: MySQL server has gone away
  27. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  28. PHP/SQL Insert Error when using Named Placeholders
  29. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment