This article mainly explains the installation and use of MySQL in Ubuntu. and the installation and use of MySQL Workbench. MySQL is an open source database software. One of Oracle's products is a database software with better performance. 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.
- installation command:
sudo apt-get updatesudo apt-get install mysql-server mysql-client安装过程仅仅须要设置root用户的password
- Test after installation:
1 view MySQL's service status:
peace@peace-rong:~$ MySQLCommunityServer#登陆:peace@peace-rong:~$ mysql -u root -pEnterpassword:#键入你安装时用的passwordWelcomeMySQL monitor. Commandsendor \g.
2 Show All databases:
Database |+--------------------+| information_schema |-- mysql元数据,基础数据| day01 |--这是我自己建立的数据库| mysql |--mysql配置数据库,当中包括用户信息。(username和password,权限管理)| 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.
- Installation
The most simple way to install violence: double-click;
Or, for example, the following:
sudo dpkg -i Mysql-workbench -community - 6.3 .5 - 1 ubu1504-amd64 Deb assumes the installation was unsuccessful: Apt-get -f Install and then enter the command again sudo dpkg -i mysql-workbench -community - 6.3 .5 - 1 ubu1504-amd64 Deb
- Test after installation:
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 password
4. You can enter SQL command operations database in an open connection in the same way as the command line.
Introduction completed;
From a little shark peace.rlovep.com
Installing MySQL and Mysql-workbench in ubuntu15.04