Using the Enterprise Manager with MySQL

From the Enterprise Manager, you have access to all functionality related to MySQL.

In the Servers treeview, expand the registered server. This will show the following treenodes:

An expanded MySQL server

Databases

This node lists all the available databases on the server. Double clicking a database will connect and open a Database Navigator window.

Context click on a database

The context menu for a database also gives you more possibilities:

•Connect

•Create New Database

•Database Options

•Backup Database

•Drop Database

Backup

This node lists the different backup projects available for this server.

Server Administration

Under this node, you can find several items to administer and monitor your MySQL server.

For more information, see:

•Processes

•Properties & Status

User Manager

Doubleclicking this node starts the User Manager, used to add, modify and delete server users.