CentOS 7.6 下安装 MySQL8.0.13

1. 下载数据库
wget -c 'https://cdn.mysql.com//Downloads/MySQL-8.0...'
解压
tar xvf mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar

安装
yum install mysql-community-libs-8.0.13-1.el7.x86_64.rpm
yum install mysql-community-libs-compat-8.0.13-1.el7.x86_64.rpm
yum install mysql-community-client-8.0.13-1.el7.x86_64.rpm
yum install mysql-community-server-8.0.13-1.el7.x86_64.rpm
设置数据库
初次安装没进去，在 /etc/my.cnf 中添加 skip-grant-tables, 使用 mysql -uroot 直接进入数据库，
修改 root 账号密码：
alter user 'root'[[[[[[[[[[[[[[[@](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)](https://learnku.com/users/8278)](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)'localhost' identified by '**';
mysql 8.0 以后默认加密方式跟 5.7 不一样：
ALTER USER 'root'[[[[[[[[[[[[[[[@](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)](https://learnku.com/users/8278)](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)'localhost' IDENTIFIED BY '**' PASSWORD EXPIRE NEVER; // 修改用户永不过期
ALTER USER 'root'[[[[[[[[[[[[[[[@](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)](https://learnku.com/users/8278)](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)'localhost' IDENTIFIED WITH mysql_native_password BY '***';// 更新一下用户的密码加密方式，修改密码
flush privileges; // 执行完刷新权限
创建新用户
CREATE USER smile[[[[[[[[[[[[[[[@](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)](https://learnku.com/users/8278)](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)% IDENTIFIED BY 'passowrd'; //# 创建账号密码
GRANT ALL ON . TO smile[[[[[[[[[[[[[[[@](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)](https://learnku.com/users/8278)](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)% WITH GRANT OPTION; // 授予远程登录权限（. 远程访问所有数据）
REVOKE all privileges ON databasename.tablename FROM 'username'[[[[[[[[[[[[[[[@](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)](https://learnku.com/users/8278)](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)'host'; // 删除某些数据权限
flush privileges;// 刷新权限
// 不常用的 --- 创建过期用户
CREATE USER smile[[[[[[[[[[[[[[[@](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)](https://learnku.com/users/8278)](https://learnku.com/users/31906)](https://learnku.com/users/29000)](https://learnku.com/users/27102)](https://learnku.com/users/25661)](https://learnku.com/users/19319)](https://learnku.com/users/10240)](https://learnku.com/users/8907)% IDENTIFIED BY '***' PASSWORD EXPIRE INTERVAL 90 DAY;
// 数据库搞定
service mysqld start restart stop