RE: grant user create privilege

2009-05-07 Thread John Clement
] > Sent: 07 May 2009 15:09 > To: Jim Lyons > Cc: John Clement; mysql@lists.mysql.com > Subject: Re: grant user create privilege > > Did you flush privileges after creating the user? > > On Thu, 2009-05-07 at 08:54 -0500, Jim Lyons wrote: > > It's hard to believe

RE: grant user create privilege

2009-05-07 Thread John Clement
this instance, but the error on "create database", which > is > essentially a "mkdir" in Unix, makes me wonder if you don't have a file > permissions error on the datadir directory. > > On Wed, May 6, 2009 at 9:14 AM, John Clement > wrote: > > >

grant user create privilege

2009-05-06 Thread John Clement
I'm clearly doing something wrong. All I want is to grant a user rights to create databases: grant create on *.* to 'user'@'localhost' identified by 'pass'; doesn't do the trick, nor does grant super on *.* to 'user'@'localhost' identified by 'pass'; The user in question was originally created