Mysql 8.0.36 Install Doc

这里介绍的是，采用rpm方式，安装mysql 8.0.36

Software: Mysql 8.0.36
Operate System: Rocky Linux 8.7
Install Way: Rpm

参考：https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html

下载rpm文件

manifest 如下:

mysql-community-common: http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/mysql-community-common-8.0.36-1.el8.x86_64.rpm

mysql-community-client-plugins: http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/mysql-community-client-plugins-8.0.36-1.el8.x86_64.rpm

mysql-community-libs: http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/mysql-community-libs-8.0.36-1.el8.x86_64.rpm

mysql-community-client: http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/mysql-community-client-8.0.36-1.el8.x86_64.rpm

mysql-community-icu-data-files: http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/mysql-community-icu-data-files-8.0.36-1.el8.x86_64.rpm

mysql-community-server: http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/mysql-community-server-8.0.36-1.el8.x86_64.rpm

开始安装

接下来，我们将这些文件，按照顺序安装。

rpm -ivh mysql-community-common-8.0.36-1.el8.x86_64.rpm

rpm -ivh mysql-community-client-plugins-8.0.36-1.el8.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.36-1.el8.x86_64.rpm

rpm -ivh mysql-community-client-8.0.36-1.el8.x86_64.rpm

rpm -ivh mysql-community-icu-data-files-8.0.36-1.el8.x86_64.rpm

rpm -ivh mysql-community-server-8.0.36-1.el8.x86_64.rpm

在安装community-server时，可能会报以下错误:

[root@vm132 Mysql]# rpm -ivh mysql-community-server-8.0.36-1.el8.x86_64.rpm
warning: mysql-community-server-8.0.36-1.el8.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
error: Failed dependencies:
        net-tools is needed by mysql-community-server-8.0.36-1.el8.x86_64
		

我们这里，使用yum的方式，来安转这个依赖:

yum install -y net-tools

启动Mysql 并进行密码初始化设置

systemctl start mysqld

# 查看自动生成的密码
grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p
 
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword!';
 
 # 接下来，让远程客户端，也可以访问mysql server
use mysql;
select host from user where user='root';
update user set host = '%' where user ='root';
flush privileges;
quit

开启firewall port & 测试访问

firewall-cmd --state
systemctl start firewalld.service 
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload


# 接下来，使用mysql-workbench，测试，是否能正常访问mysql-server