注:如果采用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
将安装包移动到指定目录
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
用命令查看初始密码
先启动MySQL服务
systemctl start mysqld
cat /var/log/mysqld.log | grep password
修改用户相关配置
使用命令登录
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;
对端口的一些配置
先用命令exit; 退出数据库
#开放数据库端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
#重启防火墙
firewall-cmd --reload
#查看当前所有tcp端口
netstat -ntlp
##查看所有3306端口使用情况
netstat -ntulp |grep 3306