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.
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 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.
In order to create a database in SQL Manager for MySQL:
- select the Database | Create Database main menu item or use the corresponding 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.
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.
In order to register a single database in SQL Manager for MySQL:
- select the Database | Register Database... main menu item or use the corresponding 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.
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 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.
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 Connect to Database toolbar button
or
- right-click the database alias and select the Connect to Database context menu item in the DB Explorer tree.
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 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 Database Properties... context menu item or use the corresponding Properties toolbar button.
See also: |