MySQL Database change name

Here first thanks to the comrade who has given the solution on the Internet

There are a lot of MySQL database beginners may encounter a change in the name of the word, maybe everyone will think of the first time to search the Internet, in fact, I am the same as everyone's psychology (hehe).

As far as I know, MySQL database changed the table name of the statement is rename table Old_table_name to New_table_name, perhaps everyone will say that the database name is also similar AH (if you use an early version, then you are right, But most of us now use a very new 5.x version)

Now, let's talk about two specific ways.

1. Under the default MyISAM storage engine: Turn off MySQL, then change the name of the database folder under the data directory in the MySQL directory to the name of the new folder and restart the MySQL service.

2. Under the default InnoDB storage engine: Create a database by the new name, delete the triggers on all the tables in the original library, and use rename table "Use command rename table Db_name.tbname to New_db_name.tbname" Copy the data tables from the original library into the new library, and then set up the previously deleted triggers in the table of the new library, in the setup of the stored procedures.

MySQL Database change name