1.下载rpm包
wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm --no-check-certificate
下载到指定目录:wget -P /APP/Mysql dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm --no-check-certificate
2.安装本地Mysql源
yum localinstall mysql-community-release-el6-5.noarch.rpm
3.验证是否安装成功
yum repolist all | grep mysql
4.修改默认版本为5.7
修改/etc/yum.repos.d/mysql-community.repo文件的5.7 enabled =1,5.6 enabled=0
vi /etc/yum.repos.d/mysql-community.repo
5.安装Mysql
yum install mysql-community-server
6.启动Mysql 及 查看Mysql服务状态
启动Mysql: service mysqld start
查看Mysql服务状态:service mysqld status
停止Mysql服务:service mysqld stop
7.安装时报错 libsasl2.so.2()(64bit)skip broken to work around the problem
问题:
8.Mysql 5.6 与 5.7初始密码区别
(1)Mysql 5.7 初始密码
linux安装MySQL5.7后,mysql为root用户随机生成了一个密码;
如果安装的是RPM包,则默认是 /var/log/mysqld.log。
启动过一次mysql才可以查看临时密码
grep 'temporary password' /var/log/mysqld.log
(2)Mysql 5.6 初始密码
Mysql 5.6 安装后root是没有默认密码的,输入密码 mysql -uroot -p,然后回车直接登录
修改初始密码:
mysqladmin -u root password "newpassword"
9.Navicat 连接 1130错误
解决方法:
root用户登录
10.彻底卸载Mysql
参考地址:https://www.cnblogs.com/nicknailo/articles/8563456.html