Installing MySQL and Mysql-workbench in ubuntu15.04

This article mainly explains the installation and use of MySQL in Ubuntu, as well as the installation and use of MySQL Workbench. MySQL is an open source database software, a product of Oracle, is a good performance database software. MySQL Workbench is a er/database modeling tool designed for MySQL.

Installation of 1.mysql

Here are the simplest ways to install via Apt-get.

1. installation command:

sudo apt-get updatesudo apt-get install mysql-server mysql-client安装过程只需要设置root用户的密码

1. Post-Installation tests:

1 view MySQL's service status:

 peace@peace-rong:~$ MySQLCommunityServer#登陆：peace@peace-rong:~$ mysql -u root -pEnterpassword:#键入你安装时用的密码WelcomeMySQL monitor.  Commandsendor \g.

2 Show All databases:

Database           |+--------------------+| information_schema |-- mysql元数据，基础数据| day01              |--这是我自己建立的数据库| mysql              |--mysql配置数据库，其中包含用户信息。（用户名和密码，权限管理）| performance_schema |--mysql数据库软件的运行数据，日志信息，性能数据| test               |     --测试数据库。空的+--------------------+5 rows in set (0.00

2. Install MySQL Workbench

The installation of the download Deb package is described here.

Choose Ubuntu Platform on the line.

1. Installation

The simplest way to install violence: Double-click on the line;

Or as follows:

sudo dpkg -i  Mysql-workbench  -community  - 6.3  .5  - 1  ubu1504-amd64   Deb if the installation is unsuccessful: Apt-get  -f  Install and re-enter the command sudo dpkg -i  mysql-workbench  -community  -  6.3  .5  - 1  ubu1504-amd64   Deb  

1. Post-Installation tests:

1. Direct Click to open:

2. On the right side of MySQL connection, click Add Connection:

3. Right-click on the connection you just created to open the connection: Enter the password.

4. In the open connection, you can enter the SQL command operation database, the same way as the command line;

Introduction completed;
From a little shark peace.rlovep.com

Installing MySQL and Mysql-workbench in ubuntu15.04