centos8 安装mysql8.0.33

一、在官网下载mysql源

 

?

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

 

 二、安装mysql

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

[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;