How can I change the database name in MySQL?

2 years ago
Liam
1 minute

To change the name of a MySQL database, you can use the RENAME DATABASE statement. Here are the steps to modify the database name:

  1. Firstly, make sure that the database you want to modify already exists and that you have sufficient permissions to change the database name.
  2. To change the name of a database in MySQL command line or any database management tool, use the following syntax:
RENAME DATABASE current_database_name TO new_database_name;

Replace current_database_name with the current name of the database you want to modify, and replace new_database_name with the new name of the database you want to modify.

For example, if you want to change the database name from “old_db” to “new_db”, you can use the following command:

RENAME DATABASE old_db TO new_db;
  1. After executing the RENAME DATABASE statement above, MySQL will change the name of the database.

Please note that the RENAME DATABASE statement cannot be used within a transaction and must be executed when there are no active connections to the database. Therefore, make sure there are no connections to the database you are planning to rename before proceeding with the modification.

bannerAds