Re: Creating a New DB / User

2009-05-13 Thread Kyong Kim
You would be fine. Grant all does not include with grant option. Ability to grant has to be given explicitly. Kyong At 08:57 AM 5/13/2009, Carlos Williams wrote: On Wed, May 13, 2009 at 11:15 AM, Michael Dykman wrote: > One thing though: your user does not need the 'WITH GRANT OPTION' bit > as

Re: Creating a New DB / User

2009-05-13 Thread Carlos Williams
2009/5/13 Pintér Tibor : > how about reading the fine  manual of the GRANT command at mysql.com? I did to avoid being lazy...go figure. I then decided to ask here before I make a mistake & I felt the fine manual was not clear enough for me... -- MySQL General Mailing List For list archives: http:

Re: Creating a New DB / User

2009-05-13 Thread Pintér Tibor
Carlos Williams írta: On Wed, May 13, 2009 at 11:15 AM, Michael Dykman wrote: One thing though: your user does not need the 'WITH GRANT OPTION' bit as that gives them permission to gratn permissions to other users, which I don't think is what you want. How do I change the bit for 'grant all'

Re: Creating a New DB / User

2009-05-13 Thread Michael Dykman
Your directive looks fine assuming dublin expects to always connect from localhost. One thing though: your user does not need the 'WITH GRANT OPTION' bit as that gives them permission to gratn permissions to other users, which I don't think is what you want. - michael dykman On Wed, May 13, 200