Ubuntu 16.04 下安装 MySQL 可以直接使用命令行安装，其版本为5.7

1
2
3
sudo apt install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev

需改编码方式，使软件支持 中文 。直接修改全局设置

1
sudo vim /etc/mysql/my.cnf

添加以下内容

1
2
3
4
5
6
7
[client]
default-character-set = utf8
[mysqld]
default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_general_ci

远程访问开启

1
2
vim /etc/mysql/mysql.conf.d/mysqld.cnf
#bind-address = 127.0.0.1

重启之后，输入命令

1
2
mysql -u root -p
mysql> show variables like '%char%';

呈现如下结果说明设置完成

1
2
3
4
5
6
7
8
9
10
11
12
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

安装可视化客户端

1
2
sudo apt install mysql-workbench
mysql-workbench #进入客户端