Linux RPM安装MySQL8.0.32

#Linux RPM安装MySQL8.0.32| 来源: 网络整理| 查看: 265

注：如果采用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

【本文地址】

公司简介

联系我们