Mysql> use mysql;
create user 'username'@'%' identified by 'any_password';
grant select on reports to 'username'@'%' identified by 'any_password';
grant all on school to 'username'@'%' identified by 'any_password';
flush privileges;
Friday, November 4, 2011
Grant Permission to the particular USER on particular TABLES
Subscribe to:
Post Comments (Atom)
Correct Syntax:
ReplyDeleteGRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;