Creating a MySQL database from PHP with username, password and all privileges

Question

I have a php file that connects to a mysql database.

I need to create a condition that, if the database is not found, will create it.

I researched and I found how to create a database with PHP. However, I need to create one of the following criteria:

DB name, DB user, Password and all privileges

Is there any way to implement this?

Answer 1

You can do it as follows:

$connection=mysql_connect('server','username',password);

$db_result=mysql_select_db('database');

if(!$db_result){

 mysql_query("CREATE USER 'stackoverflow'@'localhost' IDENTIFIED BY 'mypass';",$connection); //user

mysql_query("GRANT ALL ON db1.* TO 'stackoverflow'@'localhost');"

mysql_query("CREATE DATABASE my_db",$connection); //create database



}else{

//Database is available 

}

Answer 2

. MySQL PHP, /. , , , /, // ?

Answer 3

See MySQL Documentation for CREATE USER and GRANT .

Answer 4

$connection=mysql_connect('server','username',password);
$db_result=mysql_select_db('database');
if(!$db_result){
  mysql_query("CREATE USER 'stackoverflow'@'localhost' IDENTIFIED BY 'mypass';",$connection); //user
  mysql_query("GRANT ALL ON db1.* TO 'stackoverflow'@'localhost');"
  mysql_query("CREATE DATABASE my_db",$connection); //create database
}else{
}