Ubuntu install MySQL Visualizer mysql-workbench and simple operation

I. Using the command line to install the MySQL visualizer under Ubuntu mysql-workbench

STEP1: Installing Mysql-workbench

Scenario One: If you have installed MySQL related services, then use the following command directly to install:

sudo apt-get install Mysql-workbench

Scenario Two: If you have not installed MySQL related services, then you can refer to: Ubuntu installation Mysql-workbench

STEP2: Check if the installation is successful and if the installation is successful, you can find it in the application, such as:

Two. Simple operation of Mysql-workbench

Mysql-workbench home page such as:

STEP1: Establishing a database connection

Click the New Connection button, the symbol is "+" button, appears, in "Connection name" Enter the connection name.

Click "OK" to appear:

Click "JGirl" Connection, appear, enter the password, you can enter the Mysql-workbench edit page.

Mysql-workbench edit page, above is the menu bar, the bottom left corner is the database list display, the middle is the SQL statement writing area:

Simple operation of Step2:mysql-workbench

Edit the following statement in the SQL statement edit area:

[SQL]View PlainCopy

1. Create database University; #新建数据库university
3. Use University; #使用数据库university
5. show databases; #显示系统所有数据库

Once you have selected the code you want to execute, click the icon above to execute it, such as:

Ubuntu installation MySQL Visualizer mysql-workbench and simple operation