MySQL workbench tutorial

Original http://www.cnblogs.com/daimage/archive/2012/02/25/2367534.html

1. MySQL workbench

MySQL workbench is the database administrator,ProgramDevelopers and system planners provide visual SQL development, database modeling, and database management functions.

2. Download and install MySQL workbench

(1) When installing the latest MySQL, you can choose whether to install MySQL workbench.

(2) You can install MySQL workbench independently. Official: http://dev.mysql.com/downloads/workbench/ installation is very simple, basically is one way to next.

3. Functions and usage of MySQL workbench

Functional interface:

There are three main functional modules: SQL Development (SQL development is equivalent to the query analyzer in SQL2000), Data Modeling (Database Modeling), server administration (server management is equivalent to the Enterprise Manager in SQL2000)

 

(1) Use of SQL Development

The corresponding operations are as follows: Connection list (for selecting the established database connection), creating a connection, editing the database table, editing the SQL script, and connections management.

Click new connection to bring up the following operation interface:

Enter the server name, port, user name, and password.

The connected operation interface is as follows:

The specific operation in sql2005 sql2008 is similar, which is not described here.

(2) Use of Data Modeling

I have not used the database modeling in workbench, But I have used it again.

(3) Use of server administration

The corresponding functions are: server instance list, new service instance, Database Import and Export, security management, and server list management.

Create a service instance and enter the server name, port, user name, and password in the same way as the connection created in SQL development.

The service instance management interface is as follows:

Management provides the following functions:

Check the server status, including the number of connections and CPU usage.

Enable or disable server instances to view running logs.

View service instance logs, including storage logs, error logs, and notification logs.

 

Configuration server configuration functions I have not studied

 

Security service instance security user permissions and roles are set here. The architecture is the same as that of ms SQL.

 

Import, export, and restore data export/restore Databases

Export data:

You can select the database and data table to be exported, and export options are available. The export options here include whether to import each table to a folder corresponding to an SQL script file or all tables to an SQL file, whether to discard the stored procedure, whether to discard the Event timer, and whether to clear the data

Data Import Operation:

There are only two options for data import: one is to import all SQL scripts in a folder or to import a separate SQL script file (corresponding to the two export options respectively)

 

Author: Code brother
Source: http://daimage.cnblogs.com/
Note: original BenboArticleThe copyright is shared by the blog and I. You are welcome to repost it. However, you must keep this statement without the author's consent and provide the author's name and original text link clearly on the article page. Otherwise, you will be entitled to pursue legal liability.