MySQL Workbench management operations MySQL tutorial _mysql

Source: Internet
Author: User
Tags comments mysql query mysql tutorial mysql workbench download
A MySQL Workbench

MySQL Workbench provides DBAs and developers an integrated tool environment:

1 Database design and modeling

2 SQL Development (replaces the original MySQL Query Browser)

3 database Management (replace the original MySQL administrator)

two MySQL Workbench download and install

1) Download

Download: MySQL Workbench 6.09


2) Installation

3 Entry Database instance (SAKILA-DB)


three MySQL Workbench use

1) Server Administration

* Use Mysqlinstanceconfig to configure MySQL to run with service;

* Then create a new server instance @localhost using the MySQL Workbench Server Administration instance;

* Use the MySQL Workbench Server Administration data dump to import our database instance sakila-db, first import the Sakila schema, and then import Sakila data, Import schema as shown below:

* The imported command line can be seen in Workbench Log, and the schema is imported as follows:

Copy Code code as follows:

Mysql.exe--defaults-extra-file= "C:\users\AAA\appdata\local\temp\tmphjwdop"--host=localhost--user=root--port= 3306--default-character-set=utf8--comments < "E:\\mysql\\sakila-db\\sakila-db\\sakila-schema.sql"

The data is imported as follows:

Copy Code code as follows:

Mysql.exe--defaults-extra-file= "c:\users\AAA\appdata\local\temp\tmpbsop_e"--host=localhost--user=root--port= 3306--default-character-set=utf8--comments < "E:\\mysql\\sakila-db\\sakila-db\\sakila-data.sql"

* You can also use the MySQL Workbench Server administration data dump to export the database, export there are two formats, the first is exported to dump project folder, each table is a SQL file, The second is exported to self contained file, and all tables are exported as one SQL file;

2) SQL Development

* Create a link localhost using the new connection of the MySQL Workbench SQL development, linked to the previously imported database instance Sakila, as follows:

* Query the actor table contents of the database instance Sakila in the MySQL Workbench SQL development environment, as follows:

3) Data Modeling

* Use the MySQL Workbench Data modeling's open existing EER model to open the Sakila file in the database instance SAKILA.MWB, as shown in the following figure:

* Typically, we use the MySQL Workbench data modeling to design a database from modeling, export it as a SQL statement after modeling, and then import SQL into the database to complete the creation of the database;


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.