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
- Create database University; #新建数据库university
- Use University; #使用数据库university
- 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