Delete and recreate a MySQL database

You can delete a mysql database by going into the mysql command prompt and using the drop database command.  Therefore, if you have a database named data_base that you would like do delete, you can do the following:

#mysql
mysql>drop database data_base;

Then, to recreate that database, use the create database command

mysql>create database data_base;
Popular Posts
  • No Popular Post Available
Tags: