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