rpm部署mysql5.7.34

RPM安装MySQL

Centos7.6 + MySQL5.7.34
下载地址：https://dev.mysql.com/downloads/mysql/

# 清理环境
rpm -qa |grep -i mysql
rpm -qa |grep -i mariadb
# 普通删除模式
rpm -e mysql*
rpm -e mariadb*
# 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除
rpm -e --nodeps mysql*
rpm -e --nodeps mariadb*
# 安装 mysql5.7 所需要的依赖
yum install -y libaio
yum install -y perl-JSON
yum install -y net-tools

下载和解压安装包

wget -c https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.34-1.el7.x86_64.rpm-bundle.tar
tar xf mysql-5.7.34-1.el7.x86_64.rpm-bundle.tar

# 安装
rpm -ivh mysql-community-common-5.7.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.34-1.el7.x86_64.rpm

# 安装后的一些路径
basedir=/usr/share/mysql
datadir=/var/lib/mysql
log-error=/var/log/mysqld.log
socket=/var/lib/mysql/mysql.sock
pid-file=/var/run/mysqld/mysqld.pid

# 配置文件
/etc/my.cnf
port=5306

# 启动MySQL服务
systemctl start mysqld.service
systemctl enable mysqld.service
ps -ef | grep mysql

# 查看初始密码
grep 'temporary password' /var/log/mysqld.log

# 登录并修改密码
mysql -P5306 -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY '88stIVA#2026';

# 查看mysql版本
mysql --version
mysqladmin --version

# 开启远程访问 
grant all privileges on *.* to 'root'@'%' identified by '88stIQA#2026' with grant option; flush privileges;
flush privileges;