- 文字命令列直接刪除資料庫 dyw。
[root@kvm8 html]# mysqladmin -uroot -p123qwe drop dyw
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'dyw' database [y/N] y
Database "dyw" dropped
- 使用 php 函數
mysql_query
刪除資料庫 dywphp。
[root@kvm8 html]# vim dropdb.php
[root@kvm8 html]# cat dropdb.php
<html>
<head>
<title>Deleting MySQL Database</title>
</head>
<body>
<?php
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = '123qwe';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully<br />';
$sql = 'DROP DATABASE dywphp';
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not delete database: ' . mysql_error());
}
echo "Database dywphp deleted successfully\n";
mysql_close($conn);
?>
</body>
</html>
- 以 php 命令執行 dropdb.php 刪除 dywphp 資料庫,使用瀏覽器開啟 dropdb.php 也可以。
[root@kvm8 html]# php dropdb.php
<html>
<head>
<title>Deleting MySQL Database</title>
</head>
<body>
Connected successfully<br />Database dywphp deleted successfully
</body>
</html>
- 直接在命令列查詢 mysql 中的資料庫,dyw 及 dywphp 兩個資料庫及不見。
[root@kvm8 html]# mysql -uroot -p123qwe -e "show databases"
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+