- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
MySQL Workbench software introduction
Mysql workbench provides an integrated tool environment for DBAs and developers, which can be used for database design and modeling, SQL development (replacing the original MySQL Query Browser), database management (replacing the original MySQL Administrator)!
Mysql workbench is the official database design modeling tool launched by Mysql. It is the successor of the famous database design tool DBDesigner4. You can use MySQL Workbench designs and creates new database schemas, builds database documentation, and performs complex MySQL migrations. MySQL Workbench is the next generation of visual database design and management tools. It has both open source and commercial versions.
Introduction to MySQL Workbench functions
1. Development
MySQL Workbench provides visual tools for creating, executing and optimizing SQL queries. The SQL editor provides color syntax highlighting, reuse of SQL fragments and SQL execution history. The Database Connection Panel enables developers to easily manage database connections. The Object Browser provides instant access to database schemas and objects.
2. Management
Provides a visual console to easily manage your MySQL environment and better understand your database. Developers and DBAs can use visual tools to configure servers, manage users and view database health.
3. Design
Enables DBAs, developers or data architects to visually design, model, build and manage databases. It includes everything a data modeler needs to create complex ER models, forward and reverse engineering, and also provides key functionality to perform difficult change management and documentation tasks that often require significant time and effort.
4. Database migration
MySQL Workbench now offers a complete, easy-to-use solution for integrating Microsoft SQL Server, Sybase Migrate ASE, PostreSQL and other RDBMS tables, objects and data to MySQL. Developers and DBAs can quickly and easily convert existing applications to run on MySQL on Windows and other platforms. Migration also supports migrating from earlier versions of MySQL to the latest version.
MySQL Workbench installation steps
1. Download the Mysql workbench installation package from Huajun Software Park, unzip it, double-click to run the program, the software installation wizard will pop up, click "Next" to start the installation;
2. Customize the software installation path. The default installation path is C drive. It is recommended that you install it on D drive. However, do not choose a path with Chinese symbols when selecting. Click "Next" to install;
3. Select the installation type that best suits your needs. By default, we select the first option "Complete" for complete installation;
4. By default, click "Install" to install and wait for the installation progress to be completed.
5. The software is being installed, we are waiting patiently
6. The software is installed successfully, click finish;
How to use MySQL Workbench
How to create a database in MySQL Workbench?
Right-click in the blank space of the SCHEMAS list and select "Create Schema..." to create a database, as shown in the figure below.
In the dialog box to create a database, enter the name of the database in the Name box, and select the character set specified by the database in the Collation drop-down list. Click Apply button to create successfully, as shown in the figure below.
After completing the settings in the database creation dialog box, you can preview the SQL script of the current operation, that is, CREATE DATABASE test_db, and then click Apply button, and finally click the Finish button directly in the next pop-up dialog box to complete the creation of the database test_db, as shown in the figure below.
Use the same method to create the database test_db_char, and the specified character set defaults to UTF-8.
MySQL Workbench update log
1.Fix some bugs
2. Optimized some functions
Huajun editor recommends:
MySQL Workbench is so easy to use. It is one of the best software in the database category. I believe friends who have used it will say it is easy to use. If you don’t like it, we still have it.Data Loader,SQLyog,access tools,DBF Commander,DBeaver
it works
it works
it works