学习mysql记录 方便以后查找
mysql 版本:8.0.15;
CREATE USER qiangv0 IDENTIFIED BY ‘xxxx’;
新增用户名和密码
update user set host = ‘%’ where user = ‘qiangv0’;
flush privileges;
授权外网连接
ALTER USER ‘qiangv0’@’%’ IDENTIFIED WITH mysql_native_password BY ‘xxxx’;
设定密码插件
grant all privileges on . to ‘qiangv0’@’%’;
授予用户数据库所有操作权限
alter user ‘root’@’%’ IDENTIFIED BY ‘xxxx’;
修改root 密码
笔记记录:2019-04-01
grant select,insert,update,delete on qiang.* to qiangv0@’%’
flush privileges;
给予用户部分权限
revoke all on . from ‘qiangv0’ @’%’;
flush privileges;
回收用户所有权限