Friday, November 4, 2011

Grant Permission to the particular USER on particular TABLES

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;

1 comment:

  1. Correct Syntax:

    GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

    ReplyDelete