当前位置:首页 - 博客 - 正文

Centos7安装mysql8

下载rmp版本

https://dev.mysql.com/downloads/repo/yum/

centos7直接可用

  1. wget https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm

安装

  1. yum install https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm

清理yum缓存

  1. yum clean all

重建缓存

  1. yum makecache

安装

  1. yum install mysql80-community-release-el8-3.noarch.rpm

启动MySQL

  1. systemctl start mysqld

查看MySQL状态

  1. systemctl status mysqld

开机自启

  1. systemctl enable mysqld

重新加载系统配置,使开机自启立马有效

  1. systemctl daemon-reload

登录MySQL8

MySQL较大的变动就是,第一次安装会给root用户一个临时密码,我们需要拿到这个临时密码:

  1. grep 'temporary password' /var/log/mysqld.log

重置密码

ALTER USER USER() IDENTIFIED BY ‘Admin123!’;

修改密码(密码复杂度要满足规则)

  1. ALTER USER "root"@"%" IDENTIFIED BY "*****";