Pages - Menu

▼

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;

at

1 comment:

  1. Sunny KhetarpalApril 21, 2012 at 7:47 AM

    Correct Syntax:

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

    ReplyDelete