cpugeek Posted July 26, 2007 Share Posted July 26, 2007 How do i drop a whole database?is there a certain Sql Query i can run?Any & All help is appreciated. Link to comment Share on other sites More sharing options...
Synook Posted July 26, 2007 Share Posted July 26, 2007 DROP DATABASE dbname However, bear in mind that to run this query you have to have SQL database creation priviledges which very few servers offer. Also, you cannot be connected to a database you are trying to delete. Link to comment Share on other sites More sharing options...
cpugeek Posted July 27, 2007 Author Share Posted July 27, 2007 Thx.i found that yesterday after searching a little.but it didn't work, because it said DROP DATABASE was not allowed.is there a way i could give myself the permissions?the mysql is just my localhost that i use for development Link to comment Share on other sites More sharing options...
justsomeguy Posted July 30, 2007 Share Posted July 30, 2007 Check the documentation for MySQL to see how to assign privelages to users. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.