Re: Problem in setting Table Level Privileges

2004-03-17 Thread Victoria Reznichenko
Udbhav Shah <[EMAIL PROTECTED]> wrote: > Hi Everybody > Commands: > >> mysql -uroot > mysql> grant select,insert,update,delete on > try.TBL_MACIP to 'tryAdmin1'@'localhost'; >>mysql -utryAdmin1 > mysql> use try > mysql> select * from TBL_MACIP; >>/etc/init.d/mysql restrat >>mysql -utryAdmin1 > mys

Re: Problem in setting Table Level Privileges

2004-03-17 Thread Lokesh
Udbhav Shah wrote: Hi Everybody Commands: mysql -uroot mysql> grant select,insert,update,delete on try.TBL_MACIP to 'tryAdmin1'@'localhost'; mysql -utryAdmin1 mysql> use try mysql> select * from TBL_MACIP; /etc/init.d/mysql restrat mysql -utryAdmin1 mysql>use try ERROR 1044 (42000): Access denied

Problem in setting Table Level Privileges

2004-03-16 Thread Udbhav Shah
Hi Everybody Commands: > mysql -uroot mysql> grant select,insert,update,delete on try.TBL_MACIP to 'tryAdmin1'@'localhost'; >mysql -utryAdmin1 mysql> use try mysql> select * from TBL_MACIP; >/etc/init.d/mysql restrat >mysql -utryAdmin1 mysql>use try ERROR 1044 (42000): Access denied for user: ''@'