SV: privileges for SHOW PROCESSLIST

2001-10-05 Thread Jacob Friis Larsen
>> What privileges should I give my user so that I can do the >> SHOW PROCESSLIST on all databases ? > Process_priv Should I then do : GRANT PROCESS ON mysql.* to shark@'123.123.123.123' identified by 'sharkpassword'; - Befor

privileges for SHOW PROCESSLIST

2001-10-05 Thread Jani Tolonen
Jacob Friis Larsen writes: > What privileges should I give my user so that I can do the SHOW PROCESSLIST > on all databases ? > > Please also reply to my E-mail address. > > :) Jacob Process_priv Regards, - Jani For technical support contracts, visit https://order.mysql.com/ __ ___

Re: privileges for SHOW PROCESSLIST

2001-10-05 Thread Carl Troein
Jacob Friis Larsen writes: > What privileges should I give my user so that I can do the SHOW PROCESSLIST > on all databases ? PROCESS, I think, although it's somewhat of a guess. I wish someone with more knowledge about these things could add a clarification to that section of the manual, seein

privileges for SHOW PROCESSLIST

2001-10-05 Thread Jacob Friis Larsen
What privileges should I give my user so that I can do the SHOW PROCESSLIST on all databases ? Please also reply to my E-mail address. :) Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual)