MySQL - Deleting an Existing Database in MySQL

Deleting an Existing Database in MySQL

Q

How To Drop an Existing Database in MySQL?

✍: FYIcenter.com

A

If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database:

  $con = mysql_connect('localhost:8888', 'dev', 'iyf');
  $sql = 'DROP DATABASE fyi';
  if (mysql_query($sql, $con)) {
    print("Database fyi dropped.\n");
  } else {
    print("Database drop failed with error:\n");
    print(mysql_errno($con).": ".mysql_error($con)."\n");
  }
  mysql_close($con); 
?>

If you run this script, you will get something like this, if "dev" does not have privilege to drop database:

Database drop failed with error:
1044: Access denied for user 'dev'@'%' to database 'fyi'

⇒PHP Connections and Query Execution for MySQL

⇒⇒MySQL Database Tutorials

2017-10-23, 517👍, 0💬

Failed to Create a Database in MySQL
What Happens If You Do Not Have Privileges to Create Database in MySQL? 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 ex... 2017-11-11, 567👍, 0💬

Selecting an Existing Database in MySQL
How To Select an Exiting Database in MySQL? The first thing after you have created a connection object to the MySQL server is to select the database where your tables are located, by using the mysql_select_db() function. If your MySQL server is offered by your Web hosting company, they will assign a... 2017-10-23, 546👍, 0💬

Selecting Other User's Database in MySQL
Can You Select Someone Else Database in MySQL? If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will have no privilege to select other databases. ... 2017-10-23, 527👍, 0💬

Deleting an Existing Database in MySQL
How To Drop an Existing Database in MySQL? If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sql = 'DROP DATABASE fyi'; if (mysql_query($... 2017-10-23, 518👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.