Collections:
Failed to Create a Database in MySQL
What Happens If You Do Not Have Privileges to Create Database in MySQL?
✍: FYIcenter.com
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.
⇒ Retrieving Execution Error Message in MySQL
⇐ Creating a New Database in MySQL
2017-11-11, 1590🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...