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

2. 安装
   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

3. 设置数据库
   初次安装没进去，在/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; //执行完刷新权限

4. 创建新用户
   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

本作品采用《CC 协议》，转载必须注明作者和本文链接