Install mysql and mysql-workbench in ubuntu15.04

Install mysql and mysql-workbench in ubuntu15.04

This article describes how to install and use mysql in ubuntu and how to install and use mysql workbench. Mysql is an open-source database software, a product of Oracle, and a database software with good performance. Mysql workbench is an ER/database modeling tool designed for MySQL.

1. Install mysql

Here we will introduce the simplest way to install it through apt-get.

Installation command:

Sudo apt-get updatesudo apt-get install mysql-server mysql-client installation only requires setting the password of the root user.

Test after installation:

1. view the service status of mysql:

Peace @ peace-rong :~ $ Service mysql status ● mysql. service-MySQL Community Server # login: peace @ peace-rong :~ $ Mysql-u root-pEnter password: # enter the password Welcome to the MySQL monitor. Commands end with; or \ g.

2. Show all databases:

Mysql> show databases; + -------------------- + | Database | + -------------------- + | information_schema | -- mysql metadata, basic Data | day01 | -- this is my own database | mysql | -- mysql configuration database, which contains user information. (Username and password, permission management) | performance_schema | -- mysql database software running data, log information, performance data | test | -- test database. Null + -------------------- + 5 rows in set (0.00 sec) mysql>

2. Install mysql workbench

This section describes how to install the deb package.

Select the ubuntu platform.

Install

The simplest and most violent installation method is: Double-click it;

Or:

Sudo dpkg-I mysql-workbench-community-6.3.5-1ubu1504-amd64.deb if installation fails: apt-get-f install then re-enter the command sudo dpkg-I mysql-workbench-community-6.3.5-1ubu1504-amd64.deb

Test after installation:

1. Click Open directly:

2. Click the plus sign on the Right of mysql connection to add a connection: <喎?http: www.bkjia.com kf ware vc " target="_blank" class="keylink"> VcD4NCjxwPjxpbWcgYWx0PQ = "01" src = "http://www.bkjia.com/uploads/allimg/160109/04150361F-1.png" title = "\"/>

3. Right-click the connection you just created and click open connection: enter the password.

4. In the opened connection, you can enter SQL commands to operate the database, which is the same as the command line method;

The introduction is complete;
From a small shark peace.rlovep.com