MySQL question

[sticky_chicken]

Whilst this isn't a linux specific question, I thought this is probably the best place to post this.

I'm not much of a DBA - I can create databases and do some basic stuff with MySQL, but for the life of me, I can't figure out how to actually delete a database that I no longer want.

Can someone who knows how, let me know what syntax I have to use to do this?


Edit: This isn't on my swiftel supplied space, rather on my own Linux box.

[smithy]

http://www.mysql.com/doc/en/DROP_DATABASE.html

[sticky_chicken]

http://www.mysql.com/doc/en/DROP_DATABASE.html


Excellent. Thanks for that :)

[tli]

I just delete the actual files that the database is in. The files are kept in /var/lib/mysql .