how to delete a db

[wanted420]

ok i created a db with WinMySQLAdmin 1.4. Now how do i go about deleting it? from mysql.exe or winmysqladmin? When i created the db i could just right click in the winmysqladmin and it gave me the option to create or delete a db and now it just gives me the options to flush stuff!!! WHY???

[Norman_Graham]

WinMySQLAdmin is a GUI for setting up and manipulating your user account with MySQL. It's not for creating, populating and dropping databases. You have two options: 1. Use a DOS box (also known as command line) to control MySQL; 2. Install PHPMyAdmin, which is a GUI for MySQL. You still have to know how to write SQL commands, but PHPMyAdmin is a lot more helpful and forgiving than the command line, and removes the need to type navigational commands.

HTH

Norm

[Truti]

or just use a little php script to do the tough work!

<?php
// mySQL info
$host = "localhost"; // mySQL Server adresse
$user = "truti"; // mySQL Bruger navn
$pass = "ciafiles"; // mySQL Password

mysql_connect($host, $user, $pass);
$query = "DROP DATABASE database_name";
mysql_query($query);
mysql_close();

// recomented to use this:
// $query = "DROP DATABASE [IF EXISTS] database_name";
// if you have a mySQL 3.22 or greater!
// this will prevent errors!
?>

[wanted420]

thanks