Mysql 8.0 Yum 安装记录

从 yum repository 安装 MySQL

wget -i -c http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql-community-server
yum -y install  mysql-devel

设置 MySQL

systemctl start  mysqld.service
systemctl enable mysqld.service
systemctl status mysqld.service

可以通过下面的方式获得随机产生的临时密码

grep "password" /var/log/mysqld.log

登陆进MySQL

mysql -u root -p 

修改本地root密码 

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '${your password}';

如需要可赋予该root所有权限  

mysql> grant all privileges on *.* to 'root'@'%' with grant option;

mysql8 密码验证使用了 caching_sha2_password, 因此可改为使用 mysql_native_password 方式

mysql> alter user 'root'@'%' identified with mysql_native_password by 'your pwd';