centos8 安装mysql8.0.33

一、在官网下载mysql源

 

[root@zabbix-server ~]# wget https://dev.mysql.com/get/mysql80-community-release-el8-5.noarch.rpm

 

 二、安装mysql

[root@zabbix-server ~]# yum install -y mysql80-community-release-el8-5.noarch.rpm
[root@zabbix-server ~]# yum -y install mysql-community-server
说明：如果执行yum -y install mysql-community-server出现“无法匹配的问题”可以先执行yum module disable mysql命令关闭centos8本地的mysql模块，字后再重新执行安装mysql的命令
[root@zabbix-server ~]# yum module disable mysql
[root@zabbix-server ~]# yum -y install mysql-community-server

查看安装的版本
[root@zabbix-server ~]# mysql -V
mysql  Ver 8.0.33 for Linux on x86_64 (MySQL Community Server - GPL)

启动mysql
[root@zabbix-server ~]# systemctl start mysqld.service
查看mysql默认登录密码
[root@zabbix-server ~]# cat /var/log/mysqld.log|grep 'A temporary password'
2023-06-23T16:00:57.911789Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: bdE#jdsgX5qw
登录mysql
[root@zabbix-server ~]# mysql -uroot -pbdE#jdsgX5qw
修改密码的验证强度等级
set global validate_password.policy=LOW;
设置密码的长度
set global validate_password.length=6;
修改密码
ALTER user 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '123456';
刷新权限
flush privileges;