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";