Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you delete a database in Mysql?
- Thread starter kant
- Start date
If you're inside MySQL, you can use the command DROP DATABASE foo;
You must be running the command as root, or as the administrative user.
From outside, you can run
mysqladmin -p DROP foo
Again, you'll have to have admin privileges.
(foo being the name of your database.)
Clear that you want to destroy it? No way to recover it once you drop.
You must be running the command as root, or as the administrative user.
From outside, you can run
mysqladmin -p DROP foo
Again, you'll have to have admin privileges.
(foo being the name of your database.)
Clear that you want to destroy it? No way to recover it once you drop.
- Thread starter
- #3
- Status