]
> 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
From: Jim Lyons [mailto:jlyons4...@gmail.com]
> Sent: 07 May 2009 14:55
> To: John Clement
> Cc: mysql@lists.mysql.com
> Subject: Re: grant user create privilege
>
> It's hard to believe this to be the case since I assume you've created
> other
> databases in
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 this to be the case since I assume you've created other
> databases in this instance, but the error on "create database", which is
> essentially a "mkdir" in Unix, makes me
It's hard to believe this to be the case since I assume you've created other
databases in 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,
Are you loggin in as:
mysql -u 'user' -p
If not, you should (from the local host obviously).
The other thing to check is once you are logged in, run the following command:
mysql> show grants;
This will tell you what the grants are for the user that is logged in
(and whether or not you are