Ubuntu install MySQL Visualizer mysql-workbench and simple operation

Source: Internet
Author: User

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
    2. Use University; #使用数据库university
    3. 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

Related Article

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: info-contact@alibabacloud.com 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.