The above command will only drop the database tutorial_database if a database of that name exists view all mysql databases to view a list of databases simply issue the following command.
In your finder menu bar click go and type the following usrlocalmysqldata selectdelete the directory with the same database you want to drop you will likely get the dialog asking for the admin username and password to continue after you enter the admin credentials the directory will be gone.
A colleague of mine working on mysql database asked me how it is possible to disable a mysql database he is in situation where the client has 2 databases and application and is not sure which of the two databases the application uses therefore the client asked one of the database is disabled.
Span classnews_dtjul 23 2005spannbsp018332disable a single database mysql database forums on bytes.
If your database cannot be dropped even though you have no typos in the statement and do not miss the at the end enclose the database name in between backticks mysqlgt drop database mydatabase backticks are for databases or columns apostrophes are for data within these.
drop a database using mysqladmin you would need special privileges to create or to delete a mysql database so assuming you have access to the root user you can create any database using the mysql mysqladmin binary be careful while deleting any database because you will lose your all the data available in your database.
I just upgraded from 1004 to 1204 now when i try to drop a database in phpmyadmin it gives me an error saying that drop database statements are disabled after.
Span classnews_dtnov 20 2012spannbsp018332drop database statements are disabled in mysql phpmyadminxampp for linux this topic is now archived and is closed to further replies drop database statements are disabled in mysql phpmyadminxampp for linux by lopac1029 march 15 2012 in mysql help recommended posts i get a message of drop database statements are disabled.