//给某台电脑所有mysql操作权限grant all privileges on *.* to wjs@192.168.100.209 identified by '123456';
//给任意一台电脑mysql增删改查权限GRANT insert,update,delete,select ON *.* TO 'remote'@'%' identified by '123456'; 从上面概括得出 grant 权限 on 数据库名.数据库表名 TO 用户名@电脑IP(所有电脑则为%)identified by 密码
//去除相关账号权限revoke all on database.table from user;flush privileges;
相关账号还没有被删除
转载于:https://blog.51cto.com/shield/259017