注：如果采用RPM包安装，安装路径应在/usr/share/mysql目录下

mysqldump文件位置：/usr/bin/mysqldump

mysqli配置文件:

/etc/my.cnf或/usr/share/mysql/my.cnf

mysql数据目录在/var/lib/mysql目录下

1.上传MySQL安装包到服务器

mysql-8.0.32-1.el7.aarch64.rpm-bundle.tar

2.创建mysql目录

先在/var/local/创建一个mysql目录

进入local目录 cd /var/local

创建一个mysql目录mkdir mysql

1. 将安装包移动到指定目录

mv mysql-8.0.32-1.el7.aarch64.rpm-bundle.tar /var/local/mysql

4.压缩安装包

进入压缩包的所在路径 cd /var/local/mysql

将压缩包解压到当前路径下

tar -xvf  mysql-8.0.32-1.el7.aarch64.rpm-bundle.tar

5.开始安装MySQL

rpm -ivh mysql-community-client-8.0.32-1.el7.aarch64.rpm  --nodeps --force
rpm -ivh mysql-community-client-plugins-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-common-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-debuginfo-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-devel-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-embedded-compat-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-icu-data-files-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-libs-compat-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-server-debug-8.0.32-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-test-8.0.32-1.el7.aarch64.rpm --nodeps --force

2. 用命令查看初始密码

先启动MySQL服务

systemctl start mysqldcat /var/log/mysqld.log | grep password

3. 修改用户相关配置

使用命令登录

mysql -u root -p

#修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

#创建远程访问账户

create user 'root'@'%' identified with mysql_native_password by '123456';

#给权限

grant all privileges on *.* to 'root'@'%' with grant option;

#刷新权限

flush privileges;

4. 对端口的一些配置

先用命令exit; 退出数据库

#开放数据库端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent#重启防火墙
firewall-cmd --reload#查看当前所有tcp端口
netstat -ntlp   ##查看所有3306端口使用情况
netstat -ntulp |grep 3306