Develop Plus

Drop Database using mysqladmin:

You would need special privileges to create or to delete a MySQL database. So assuming you have access to root user, you can create any database using mysql mysqladmin binary.

Be careful while deleting any database because you will lose your all the data available in your database.

Here is an example to delete a database created in previous chapter:

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

This will give you a warning and it will confirm if you really want to delete this database or not.

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 'TUTORIALS' database [y/N] y
Database "TUTORIALS" dropped

Drop Database using PHP Script:

PHP uses mysql_query function to create or delete a MySQL database. This function takes two parameters and returns TRUE on success or FALSE on failure.

Syntax:

bool mysql_query( sql, connection );

Parameter	Description
sql	Required - SQL query to create or delete a MySQL database
connection	Optional - if not specified, then last opened connection by mysql_connect will be used.

Example:

Try out the following example to delete a database:

<html>
<head>
<title>Deleting MySQL Database</title>
</head>
<body>
<?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<br />';
$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);
?>
</body>
</html>

WARNING: While deleting a database using PHP script, it does not prompt you for any confirmation. So be careful while deleting a MySQL database.

Comments

Popular posts from this blog

The Windows Firewall with Advanced Security is a firewall that runs on the Windows Server 2012 and is turned on by default. The Firewall settings within Windows Server 2012 are managed from within the Windows Firewall Microsoft Management Console . To set Firewall settings perform the following steps − Step 1 − Click on the Server Manager from the task bar → Click the Tools menu and select Windows Firewall with Advanced Security. Step 2 − To see the current configuration settings by selecting Windows Firewall Properties from the MMC. This allows access to modify the settings for each of the three firewall profiles, which are – Domain, Private and Public and IPsec settings. Step 3 − Applying custom rules, which will include the following two steps − Select either Inbound Rules or Outbound Rules under Windows Firewall with Advanced Security on the left side of the management console...

In this chapter, we will see how to configure WSUS and tune it. The following steps should be followed for configuring it. Step 1 − When you open it for the first time, you should do it by going to “Server Manager” → Tools → Windows Server Update Services, then a Configuration wizard will be opened and then click → Next. Step 2 − Click “Start Connecting” → Wait until the green bar is full and then → Next. Step 3 − Check the box for which the updates want to be taken, I did for English and then → Next. Step 4 − Check the box for all the products which you want to update. It is just for Microsoft products and it is recommended to include all the products related to Microsoft and then → Next. Step 5 − Choose the classification updated to be downloaded, if you have a very good internet speed, then check all the boxes, otherwise just check “Critical Updates”. Step 6 − Now we should schedule the updates which I will recommend to do it a...

The IIS ( Internet Information Services ) is facing internet all the time. So, it is important to follow some rules in order to minimize the risk of being hacked or having any other security issues. The first rule is to take all the updates of the system regularly. The second one is to create different application polls to this, which can be done by following the steps shown below. Step 1 − You have to go to: Server Manager → Internet Information Services(IIS) Manager → Application Pulls. Step 2 − Click “Sites” → Right Click “Default Website” → Manage Website → Advance Settings. Step 3 − Select the Default Pools. Step 4 − Disable the OPTIONS method, this can be done by following the path – Server Manager → Internet Information Services (IIS) Manager → Request Filtering. Step 5 − In the action pane, select "Deny Verb" → Insert ‘OPTIONS’ in the Verb → OK. Step 6 − Enable Dynamic IP Restrictions blocks by going to – IIS Manager → Double...