centos 安装mysql 8

centos 安装mysql 8

• 先删除系统中的mysql 或者 MariaDB
  • for i in $(rpm -qa|grep mysql);do rpm -e $i --nodeps;done
    rm -rf /var/lib/mysql && rm -rf /etc/my.cnf
• yum安装资源库
  • yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
• 开始安装并设置自动启动
  • yum install mysql-community-server
    设置自动启动
    systemctl start mysqld
    systemctl enable mysqld

修改默认密码

-	cat /var/log/mysql.log | grep "password"
-	设置mysql的密码规则，不然修改密码时会报错
	-	set global validate_password.policy=0;  
	-	set global validate_password.length=1;  
-	修改密码并刷新
	-	ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
	-	flush privileges;  

OK啦，这样最基本的安装就完成了！