MYSQLl给用户授予数据库表权限

给targetUserName用户授予databaseName单个数据库权限

grant all privileges on databaseName.* to targetUserName@"%" identified by ‘targetPassword‘;
grant select,delete,update,insert on databaseName.* to targetUserName@"%" identified by ‘targetPassword‘;
grant select on databaseName.* to targetUserName@"%" identified by ‘targetPassword‘;

原文：https://www.cnblogs.com/zhuitian/p/12358274.html