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,
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 wonder
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 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
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 this to be the case since I assume you've
created other
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
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