添加用户并赋予全部权限
create user 'user_name'@'%' identified by 'password';
-- GRANT all privileges ON db_name.table_name TO 'user_name'@'%';
GRANT all privileges ON db_name.* TO 'user_name'@'%';
flush privileges;
- % 表示任意ip可以访问。也可以改成localhost。
- db_name,table_name 可以用*替换
删除用户
drop user 'user_name'@'%';
去掉用户权限
revoke select on db_name.table_name from 'user_name'@'%';
参考
https://blog.csdn.net/weixin_42480540/article/details/113187212
https://www.pianshen.com/article/99061735391/