下载rmp版本
https://dev.mysql.com/downloads/repo/yum/
centos7直接可用
wget https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm
安装
yum install https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm
清理yum缓存
yum clean all
重建缓存
yum makecache
安装
yum install mysql80-community-release-el8-3.noarch.rpm
启动MySQL
systemctl start mysqld
查看MySQL状态
systemctl status mysqld
开机自启
systemctl enable mysqld
重新加载系统配置,使开机自启立马有效
systemctl daemon-reload
登录MySQL8
MySQL较大的变动就是,第一次安装会给root用户一个临时密码,我们需要拿到这个临时密码:
grep 'temporary password' /var/log/mysqld.log
重置密码
ALTER USER USER() IDENTIFIED BY ‘Admin123!’;
修改密码(密码复杂度要满足规则)
ALTER USER "root"@"%" IDENTIFIED BY "*****";