Mysql环境
mysql镜像下载地址:https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-Cluster-8.0/
一、步骤
1.先卸载自带的数据库
rpm -qa|grep mari
rpm -e --nodeps mariadb-libs
rpm -e --nodeps marisa
2.下载
mysql-8.0.27-1.el7.aarch64.rpm-bundle.tar
解压 tar -xvf mysql-8.0.27-1.el7.aarch64.rpm-bundle.tar
3.安装
rpm -ivh mysql-community-common-8.0.27-1.el7.aarch64.rpm
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.aarch64.rpm
rpm -ivh mysql-community-libs-8.0.27-1.el7.aarch64.rpm
rpm -ivh mysql-community-client-8.0.27-1.el7.aarch64.rpm --nodeps
rpm -ivh mysql-community-server-8.0.27-1.el7.aarch64.rpm
4.运行systemctl start mysqld启动mysql
5.设置开机启动 systemctl enable mysqld
6.查看初始密码
grep "password" /var/log/mysqld.log
7.复制密码
运行登录
mysql -uroot -p[复制的密码]
8.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'wangfan123';
flush privileges;
9.外网连接
开放端口
firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload
查看端口是否开放
firewall-cmd --query-port=3306/tcp
外网连接不上mysql
进入mysql数据库
use mysql;
查询用户
select host,user from user;
调整方法:
执行
update user set houst='%' where user = 'root';
执行刷新权限:
flush privileges;
防火墙
永久关闭防火墙
systemctl disable firewalld.service
查看防火墙状态
systemctl status firewalld
关闭防火墙
systemctl stop firewalld
开启防火墙
systemctl start firewalld
若遇到无法开启
先用:systemctl unmask firewalld.service
再用:systemctl start firewalld.service
二、问题
在安装过程中报错解决:
![image.png](https://img-blog.csdnimg.cn/img_convert/7f6f7b82d81e4f92f4c856682c576f89.png#clientId=u3eabd6ba-cf47-4&crop=0&crop=0&crop=1&crop=1&from=paste&height=212&id=uccaf8a8d&margin=[object Object]&name=image.png&originHeight=212&originWidth=1544&originalType=binary&ratio=1&rotation=0&showTitle=false&size=202851&status=done&style=none&taskId=ub78a82c1-7448-4639-9857-76354a8ea68&title=&width=1544)
在安装过程中,如有报上图错误:可在其后加--nodeps
问题一:
![image.png](https://img-blog.csdnimg.cn/img_convert/7330ae9a99874027858344f5f2ca182c.png#clientId=u3eabd6ba-cf47-4&crop=0&crop=0&crop=1&crop=1&from=paste&height=39&id=ufa5cd9ac&margin=[object Object]&name=image.png&originHeight=41&originWidth=763&originalType=binary&ratio=1&rotation=0&showTitle=false&size=25931&status=done&style=none&taskId=u373c198e-8d4e-48a5-babb-8bb5854b641&title=&width=733.5)
解决:https://blog.csdn.net/weixin_40660408/article/details/103409769
1.先查看Mysql关联的lib命令
cd /usr/bin/
ldd mysql
![image.png](https://img-blog.csdnimg.cn/img_convert/0a206135eb40008dddf4036203f85984.png#clientId=u3eabd6ba-cf47-4&crop=0&crop=0&crop=1&crop&