The following is script to do that
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON [db_name].* TO '[db_user]'@'[db_host]' IDENTIFIED BY '[db_user_password]';From that script, if you want to limit user privileges just on manipulating data, you should use select, insert, update, delete.
Because of db_host parameter, we have to define each user for each different host.
Thanks for sharinng
ReplyDelete