因为某些原因公司需要卸载MySQL5.6版本,升级至5.7
1.删除MySQL安装包
yum list installed | grep mysql
mysql-community-client.x86_64 5.6.42-2.el7 @mysql56-community
mysql-community-common.x86_64 5.6.42-2.el7 @mysql56-community
mysql-community-libs.x86_64 5.6.42-2.el7 @mysql56-community
mysql-community-release.noarch el7-5 installed
mysql-community-server.x86_64 5.6.42-2.el7 @mysql56-community
卸载除了noarch的其他四个。
参考:https://blog.csdn.net/Victor2code/article/details/104592984
2.安装MySQL5.7
yum -y install mysql-community-server
但到安装这一步就报错了:
"MySQL 5.7 Community Server Development Milestone Release" 的 GPG 密钥已安装,但是不适用于此软件包。请检查源的公钥 URL 是否配置正确。
查了一下需要import mysql的公钥到RPM的配置中,直接运行:
rpm --importhttps://repo.mysql.com/RPM-GPG-KEY-mysql-2022
重新安装后成功!
参考:https://blog.csdn.net/weixin_53768277/article/details/124119115
3.启动
systemctl start mysqld
4.登陆
mysql -uroot -p
报错:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
账号密码不对,因为安装的过程中自动生成了默认密码,运行如下可以获得密码:
grep 'temporary password' /var/log/mysqld.log
输出密码:
[Note] A temporary password is generated for root@localhost: =vj,cDkyW9aay
重新登录:
mysql -uroot -p=vj,cDkyW9aay
成功!
因为是默认密码,登陆成功后需要修改密码(复杂一点,包含很多特殊符号的长串密码)
mysql> alter user 'root'@'localhost' identified by '我是复杂密码';
修改mysql端口号,最好修改一下端口号,不然很容易被攻击。
查看当前端口号:
mysql> show global variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
退出mysql,编辑 vim /etc/my.cnf 文件,在末尾增加一行:
port=11286
保存文件然后重启MySQL。