https://habrahabr.ru/post/105954/ mht- MySQL шпаргалки

Create a database using PDO in PHP

<?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());
    }
?>