Simple tutorial for deleting a MySQL database _ MySQL

This article describes how to delete a MySQL database. Use mysqladmin to delete a database:

Special permissions are required to create or delete a MySQL database. Therefore, we assume that you can use mysql mysqladmin binary to create any database for root user access.

Delete any database with caution because it will lose all available data in the database.

[root@host]# mysqladmin -u root -p drop TUTORIALSEnter password:******

Use a PHP script to delete a database:

PHP uses the mysql_query function to create or delete a MySQL database. This function has two parameters. if success returns TRUE or failure, FALSE is returned.
Example:

bool mysql_query( sql, connection );

Example:

In the following example, delete a database:

Deleting MySQL Database - by www.jb51.com<?php$dbhost = 'localhost:3036';$dbuser = 'root';$dbpass = 'rootpassword';$conn = mysql_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die('Could not connect: ' . mysql_error());}echo 'Connected successfully
';$sql = 'DROP DATABASE TUTORIALS';$retval = mysql_query( $sql, $conn );if(! $retval ){ die('Could not delete database: ' . mysql_error());}echo "Database TUTORIALS deleted successfully\n";mysql_close($conn);?>

Warning when deleting a database, the PHP script will not prompt any confirmation. Therefore, be careful when deleting a MySQL database.