Failed to Create a Database in MySQL

Q

What Happens If You Do Not Have Privileges to Create Database in MySQL?

✍: FYIcenter.com

A

If your MySQL server is provided by your Internet service company, your user account will most likely have no privilege to create new databases on the server. In that case, your CREATE DATABASE statement will fail. Here is an example of using a less privileged user account to create a new database:

<?php
  $con = mysql_connect('localhost:8888', 'guest', 'pub');
  $sql = 'CREATE DATABASE fyicenter';
  if (mysql_query($sql, $con)) {
    print("Database fyi created.\n");
  } else {
    print("Database creation failed.\n");
  }
  mysql_close($con); 
?>

If you run this script, you will get something like this:

Database creation failed.

 

PHP Connections and Query Execution for MySQL

⇒⇒MySQL Database Tutorials

2017-11-11, 234👍, 0💬