Breaking News: Grepper is joining You.com. Read the official announcement!

create DB and user in mysql php

Indian Gooner answered on August 17, 2022 Popularity 5/10 Helpfulness 2/10

answer create DB and user in mysql php

create DB and user in mysql php

Comment

## make sure you connect first to mysql with a super user (ex: root)
mysql_connect('localhost', 'root', 'password');

$dbName = 'database_name'; // new database name
$dbUser = 'db_user';       // new user name
$dbPass = 'db_pass';       // new user password

$queries = array(
    "CREATE DATABASE `$dbName` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci",
    "CREATE USER '$dbUser'@'localhost' IDENTIFIED BY '$dbPass'",
    "GRANT USAGE ON * . * TO '$dbUser'@'localhost' IDENTIFIED BY '$dbPass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0",
    "GRANT SELECT , INSERT , UPDATE, DELETE ON `$dbName` . * TO '$dbUser'@'localhost'",
    "FLUSH PRIVILEGES"
);

foreach($queries as $query) {
    echo 'Executing query: "'.htmlentities($query).'" ... ';
    $rs = mysql_query($query);
    echo ($rs ? 'OK' : 'FAIL') . '<br/><br/>';
}

Popularity 5/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: mysql php

Link to this answer
Share Copy Link

Contributed on Aug 17 2022

Indian Gooner

0 Answers Avg Quality 2/10

create DB and user in mysql php

Contents

More Related Answers

create DB and user in mysql php

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.