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

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

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