CENTOS7用RPM安装MYSQL8.0方法

最新推荐文章于 2025-02-06 17:39:37 发布

sunfor

最新推荐文章于 2025-02-06 17:39:37 发布

阅读量1k

点赞数 2

分类专栏： Mysql Linux

本文链接：https://blog.youkuaiyun.com/sunfor/article/details/115940357

版权

Linux 同时被 2 个专栏收录

4 篇文章

订阅专栏

Mysql

1 篇文章

订阅专栏

本文介绍如何在Linux环境下卸载MariaDB并安装MySQL 8.0，包括初始化配置、权限设置及调整加密规则等步骤，确保数据库稳定运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、卸载之前安装的mariadb
rpm -qa |grep mariadb 查看已安装的mariadb
rpm -e mariadb-libs-5.xxx 按提示文件名卸载mariadb
rpm -qa |grep mariadb 再查看mariadb是否全部卸载完

2、上传MYSQL8.0安装包，并解压：
cd /usr/local/
mkdir mysql
cd mysql
把下载好的安装包通过Mobaxterm软件上传到MYSQL这个目录
解压软件
tar -xvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar
提示如下：
mysql-community-client-8.0.23-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm
mysql-community-common-8.0.23-1.el7.x86_64.rpm
mysql-community-devel-8.0.23-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.23-1.el7.x86_64.rpm
mysql-community-libs-8.0.23-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.23-1.el7.x86_64.rpm
mysql-community-server-8.0.23-1.el7.x86_64.rpm
mysql-community-test-8.0.23-1.el7.x86_64.rpm

安装下面几个包：
rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm --nodeps --force

查看已安装包
rpm -qa | grep mysql
提示如下：
mysql-community-libs-8.0.23-1.el7.x86_64
mysql-community-common-8.0.23-1.el7.x86_64
mysql-community-server-8.0.23-1.el7.x86_64
mysql80-community-release-el7-1.noarch
mysql-community-client-8.0.23-1.el7.x86_64

2、对MYSQL数据库进行实始化等相关配置：
mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld
cat /var/log/mysqld.log | grep password
提示如下：
2021-04-14T08:20:26.712099Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: S=Pm!&Xyq2jh
2021-04-21T02:48:46.640364Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: hoxg2fL-r1Fx最后这个就是初始密码
登陆MYSQL，修改初始化密码：
mysql -uroo -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';（修改ROOT账号的密码为root）

3、进行远程访问授权：

mysql> create user 'root'@'%' identified with mysql_native_password by 'root';

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

mysql> flush privileges;

4、修改加密规则，MYSQL8.0与5.0的加密不一样，面现在可视化工具只支持旧的加密方式：
masql > ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
mysql > flush privileges;
mysql > select version();

后话：

另外也有人初始化时，用下面第一行这个命令进行空密码设置（我没度过）。