Navicat MySQL download for Windows - Database Management

Navicat MySQL provides all the tools you need to manage and navigate databases. Note that to start working with databases in Navicat MySQL you are to establish the connection (see Connection Settings).

Create Database

To create a database

Double-click the connection to open in the navigation pane.
Right-click the opened connection and choose New Database.
or
Right-click any existing database and choose New Database.
Fill in the required information:

Enter database name
Set the name for a new database.

Character set
The Character set specifies the default database character set.

Collation
The Collation specifies the default database collation.

Drop Database

To drop a database

Right-click the database in the navigation pane and choose Drop Database.
Confirm removing in the dialog window.

Note: This operation is irreversible.

Open Database

To open a hidden database

Double-click the connection to open in the navigation pane.
Right-click the opened connection and choose Open Database.
Enter the database name.

To open a database which shows in the navigation pane

Double-click the database to open in the navigation pane.
or
Right-click the database and choose Open Database.

Close Database

To close a database

Right-click the database in the navigation pane and choose Close Database.

Edit Database

To edit a database

Right-click the database in the navigation pane and choose Database Properties.

Please notice that MySQL does not support renaming database through its interface at this moment.

Access the directory in which databases being stored. By default, all databases store within a directory called data under MySQL Installation folder. For example: C:\mysql5\data.

Note: You must stop MySQL before you can rename the database.