Online Documentation for SQL Manager for MySQL

Database Management


SQL Manager for MySQL provides a number of tools you may need to manage your MySQL databases.

Find the list of common database management operations for working in SQL Manager below.

 

 

Unregistering Hosts

 

In order to unregister a host in SQL Manager for MySQL:

  • select the host to unregister in the DB Explorer tree;
  • select the Database | Unregister Host main menu item or use the corresponding btnUnregisterHost Unregister Host toolbar button

or

  • right-click the host alias and select the Unregister Host context menu item in the DB Explorer tree;
  • confirm unregistering in the corresponding dialog window.

 

Creating Databases

 

In order to create a database in SQL Manager for MySQL:

  • select the Database | Create Database main menu item or use the corresponding btnCreateDB Create Database toolbar button;
  • set all the necessary options using Create Database wizard which guides you through the entire process of creating a new database.

 

Dropping Databases

 

In order to drop a database in SQL Manager for MySQL:

  • select the database to drop in the DB Explorer tree;
  • select the Database | Drop Database main menu item;
  • confirm dropping in the corresponding dialog window.

 

Registering Databases

 

In order to register a single database in SQL Manager for MySQL:

  • select the Database | Register Database... main menu item or use the corresponding btnRegisterDB Register Database toolbar button

or

  • right-click any database alias and select the Register Database... context menu item in the DB Explorer tree;
  • set all the necessary options using Register Database wizard which guides you through the entire process of database registration.

 

Unregistering Databases

 

In order to unregister a database in SQL Manager for MySQL:

  • select the database to unregister in the DB Explorer tree;
  • select the Database | Unregister Database main menu item or use the corresponding btnUnregisterDB Unregister Database toolbar button

or

  • right-click the database alias and select the Unregister Database context menu item in the DB Explorer tree;
  • confirm unregistering in the corresponding dialog window.

 

Connecting to Databases

 

In order to connect to a database in SQL Manager for MySQL:

  • select the database to connect to in the DB Explorer tree;
  • select the Database | Connect to Database main menu item or use the corresponding btnConnectToDB Connect to Database toolbar button

or

 

Disconnecting from Databases

 

In order to disconnect from a database in SQL Manager for MySQL:

  • select the database to disconnect from in the DB Explorer tree;
  • select the Database | Disconnect from Database main menu item or use the corresponding btnDisconnectFromDB Disconnect from Database toolbar button

or

  • right-click the database alias and select the Disconnect from Database context menu item in the DB Explorer tree.

 

Viewing and Editing Database Registration Info

 

In order to view/edit database registration info in SQL Manager for MySQL:

  • select the database or any of its objects in the DB Explorer tree;
  • select the Database | Database Registration Info... main menu item

or

  • right-click the database alias or any of its objects and select the Database Registration Info... context menu item in the DB Explorer tree.

 

Viewing and Editing Database Properties

 

In order to view/edit database properties in SQL Manager for MySQL:

  • select the database in the DB Explorer tree;
  • right-click the database alias and select the btnDBProperties Database Properties... context menu item or use the corresponding Properties toolbar button.