不知道linux是啥的绕行, 知道不会用的绕行。
1. 下载8.0.20 https://dev.mysql.com/downloads/mysql/ wget或者下载后上传服务器,你开心就好
2. 解压 tar -vxf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar, 文件list如下
mysql-community-libs-8.0.20-1.el7.x86_64.rpm
mysql-community-client-8.0.20-1.el7.x86_64.rpm mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm
mysql-community-common-8.0.20-1.el7.x86_64.rpm mysql-community-server-8.0.20-1.el7.x86_64.rpm
mysql-community-devel-8.0.20-1.el7.x86_64.rpm mysql-community-test-8.0.20-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpm
3. 安装 rpm -ivh 文件
安装顺序如下: common , libs, client, server
可能遇到的错误: 某某1(mariadb-libs) 被 某某2(mysql-community-libs-8.0.20-1.el7.x86_64) 取代
解决方案: 卸载大法好, yum remove 某某1
4. 设置配置文件:
/etc/my.cnf
4. 初始化
mysqld --initialize;
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld;
5. 查询数据初始密码,并修改
cat /var/log/mysqld.log | grep password
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
剩下的需要修改远程连接的可参照我文章中【mysql 8.0.20安装-windows版本】
7. 查看防火墙状态,systemctl status firewalld.service
![](https://img.haomeiwen.com/i12660357/b5485e7dcf0fb57d.png)
8. 添加通过端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent // 永久生效
9. 查看是否添加成功
firewall-cmd --zone=public --list-ports
10. 结果
![](https://img.haomeiwen.com/i12660357/ea96ccc33aa9b674.png)
不同环境可能需要组件依赖啥的缺失,遇到问题自行找度娘解决。
网友评论