Centos9 部署mysql

rpm -qa|grep mariadb 删除db

MySQL :: Download MySQL Yum Repository 下载官网源

rpm -Uvh mysql80-community-release-el7-3.noarch.rpm 解压官网源

yum repolist可以看到mysql相关资源

yum update

选择MySQL版本

shell> sudo yum-config-manager --disable mysql80-community shell> sudo yum-config-manager --enable mysql57-community

yum install mysql-community-server 安装

grep "password" /var/log/mysqld.log 初始密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'W5237478a!.'; 更改密码

set global log_bin_trust_function_creators = 0;

运行flush privileges;使密码设置生效 DBPassword=数据库密码