Create a database
To create a new database, select the server where the database should be created in the Server Navigator, click New Database in the Connection Menu.

After you create a new database, you must perform additional steps to define the tables, queries and reports that will make up your database.

Open a database
After connecting to the server, Double click on the preferred database to show all the tables, queries and backups associated with the database.

Rename a database
MySQL does not support the rename of a database through its interface at the moment, but you can rename the database if you have access to the directory in which MySQL stores its databases.

For default MySQL installations, this is usually in the Data folder under the directory where MySQL was installed. Locate the name of the database you want to rename under the Data folder and rename it.
NOTE: You must stop MySQL before you can rename the database

Delete a database
To delete a database, select the database in the Server Navigator and click Drop Database in the connection menu. A confirmation dialog will prompt you before deleting the database.

NOTE: Be very careful when deleting a database, the operation is irreversible.

Copy a database
You can copy a database from one server to another or to the same server under a different database name by using Navicat's Data Transfer function.

Move a database
You can move a database from one server to another by copying the database to where you want it and then delete the original one.

Maintain a database
Please visit Maintaining your Database/Tables for details