mysql创建用户只能访问数据库中一张表

#创建用户testUser, 密码12345，%表示所有机器，可以自行指定ip

指定ip: CREATE USER 'user02'@'10.4.127.171' IDENTIFIED BY 'user02';
所有ip: CREATE USER 'user02'@'%' IDENTIFIED BY 'user02';

#给此用户分配task表的select权限

指定ip: GRANT SELECT ON `demo_back`.test TO 'user02'@'10.4.127.171';
所有ip: GRANT SELECT ON `demo_back`.test TO 'user03'@'%';

#给此用户分配task表的全部权限

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON `dbtest`.task TO 'testUser'@'%';

#刷新数据库权限

FLUSH PRIVILEGES;

#查看当前用户及权限

SELECT user,host FROM mysql.user;

#让root用户可以远程访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;