CentOS6.5重装Mysql5.7

卸载

step1.查看已安装的Mysql

yum list installed |grep mysql

step2.删除安装的mysql

yum remove mysql57-community-release.noarch

 step3.删除所有的mysql文件

find / -name mysql

执行rm -rf命令删除

rm -rf /var/lib/mysql

 安装

step1.重新下载mysql的rpm

wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

step2.安装Mysql的yum源 

rpm -ivh mysql57-community-release-el6-9.noarch.rpm

step3.安装Mysql

yum install mysql-community-server

安装中出错:

Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
           Requires: libsasl2.so.3()(64bit)
Error: Package: mysql-community-client-5.7.27-1.el7.x86_64 (mysql57-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)
Error: Package: mysql-community-libs-5.7.27-1.el7.x86_64 (mysql57-community)
           Requires: libc.so.6(GLIBC_2.14)(64bit)
Error: Package: mysql-community-client-5.7.27-1.el7.x86_64 (mysql57-community)
           Requires: libc.so.6(GLIBC_2.14)(64bit)
Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
           Requires: systemd
Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
           Requires: libc.so.6(GLIBC_2.17)(64bit)
Error: Package: mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

尝试方案一：解决了我在CentOS6上安装5.7上述报错

yum clean all 

然后重新执行 

yum install mysql-community-server

尝试方案二：解决了我在CentOS7上安装5.7上述报错

修改vim /etc/yum.repos.d/mysql-community.repo 源文件

[mysql57-community]

name=MySQL 5.7 Community Server

## baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/   

baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/

enabled=1

gpgcheck=0

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql   

 配置

step1.启动Mysql服务

service mysqld start

step2.给root账号配置密码；mysql5.7开始，在服务器启动时，如果服务器的数据目录为空，'root'@'localhost' 创建一个超级用户帐户。设置超级用户的密码并将其存储在错误日志文件中。要显示它，请使用以下命令：

 grep 'temporary password' /var/log/mysqld.log

step3.修改mysql密码

mysql -uroot -p

此时的password便是step2命令显示的密码；登录成功后执行命令

ALTER USER 'root'@'localhost' IDENTIFIED BY '您的密码';

注意
MySQL的 validate_password 插件默认安装。这将要求密码包含至少一个大写字母，一个小写字母，一个数字和一个特殊字符，并且密码总长度至少为8个字符。

step4.使用navicat连接

出现类似这种错误可以通过执行如下命令解决