1、查看CentOS自带MySQL 5.1组件并卸载
rpm -qa | grep -i mysql
rpm -e --nodeps mysql-libs-5.1.61-4.el6.x86_64
2、rpm -ivh numactl-2.0.9-2.el6.x86_64.rpm
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
3、rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.18-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.18-1.el6.x86_64.rpm
4. 修改数据库编码。
为了保证数据库能正确处理中文,我们需要设定数据库默认的编码为utf8。修改/etc/my.cnf文件,并在其中加入以下内容:
[client]
default-character-set=utf8mb4
[mysqld]
character_set_server=utf8mb4