rpm部署mysql8.0.25

RPM安装MySQL

Centos7.6 + MySQL8.0.25
下载地址：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*
yum remove mysql-libs

# 安装 mysql8.0 所需要的依赖
yum install -y libaio
yum install -y perl-JSON
yum install -y net-tools

下载和解压安装包

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

# 安装

rpm -ivh mysql-community-common-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.25-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=8306

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

# 查看初始密码
grep 'temporary password' /var/log/mysqld.log
# 查看mysql版本
mysql --version
mysqladmin --version

# 为了保证数据库目录与文件的所有者为 mysql 登录用户，如果你是以 root 身份运行 mysql 服务，需要执
行下面的命令初始化
mysqld --initialize --user=mysql

# 登录并修改密码
mysql -P 8306 -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY '88stIVA#2026';
# 开启远程访问数据库
use mysql;
update user set host = '%' where user ='root';
# 配置navicat工具连接（分析是加密方式变了）
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '88stIVA#2026';

# 刷新授权
flush privileges;