Mysql5.7创建用户与授权

use mysql;

select host,user,authentication_string,plugin from user;

## 使用plugin中方式设置用户密码
create user ‘use'@'%' identified by '2022'; 

## 授权远程访问
grant all privileges on *.* to 'use'@'%' with grant option;

## 刷新权限
flush privileges;

## 初始密码登录数据库后，更新用户密码
alter user 'root'@'localhost' identified by '2022';