How to rename the database name in Navicat for MySQL

1. In Navicat for MySQL, when editing the database, the database name cannot be edited, as shown in Figure 1

Figure 1

2. Rename the database in phpmyadmin, it can be seen that phpmyadmin can support the operation of direct rename, as shown in Figure 2

Figure 2

3. Prepare to rename g-s-yii2-app-advanced-test in Navicat for mysql, and create a new database: gsy2aa-test, as shown in Figure 3

Figure 3

4. On the database g-s-yii2-app-advanced-test, dump SQL files – structure and data, export files: g-s-yii2-app-advanced-test.sql, as shown in Figure 4

Figure 4

5. On the database GSY2AA-TEST, run the SQL file, select the SQL file just exported, as shown in Figure 5

Figure 5

6. Refresh on the database GSY2AA-TEST to determine that the structure and data are consistent with the database G-S-YII2-App-Advanced-Test, as shown in Figure 6

Figure 6

7. Delete the database g-s-yii2-app-advanced-test, as shown in Figure 7

Figure 7