1）前提条件，配置阿里源
mv /etc/yum.repos.d/* /tmp/

 

wget http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm
rpm -ivh mysql57-community-release-el6-8.noarch.rpm –nodeps –force
yum -y install yum-utils (安装yum-config-manager 命令) 如果执行这个命令报错，请将192.168.101.30 root/1qaz@WSX  /etc/yum.repos.d/源拷贝到同目录（阿里源）
yum-config-manager –disable mysql57-community
yum-config-manager –enable mysql56-community
yum install mysql-community-server

service mysqld start
mysql -uroot -p (空密码，直接回车即可)
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘root’);

mysql> show variables like ‘%character%’;
+————————–+—————————-+
| Variable_name | Value |
+————————–+—————————-+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+————————–+—————————-+

set character_set_client = utf8;

set character_set_server = utf8;

set character_set_connection = utf8;

set character_set_database = utf8;

set character_set_results = utf8;

set collation_connection = utf8_general_ci;

set collation_database = utf8_general_ci;

set collation_server = utf8_general_ci;
create database app_relation character set utf8;

到此数据库安装完成。