Creating a New DB / User

2009-05-13 Thread Carlos Williams
I have used MySQL twice in my career so I did read the MySQL How-to page and just wanted to ask here if what I did as correct based on what I wanted to do. I just wanted to create a new database in MySQL called webmail and then also create a new user who limited to only accessing the 'webmail'

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,

Creating a New DB / User

2009-05-13 Thread Carlos Williams
On Wed, May 13, 2009 at 11:15 AM, Michael Dykman mdyk...@gmail.com 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' via

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 mdyk...@gmail.com 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

Re: Creating a New DB / User

2009-05-13 Thread Carlos Williams
2009/5/13 Pintér Tibor tib...@tibyke.hu: 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

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 mdyk...@gmail.com wrote: One thing though: your user does not need the 'WITH GRANT