'@'localhost'; flush privileges; quit
mysql -u user -ppassword
mysql create database testdb1;
mysqlcreate database testdb2;
Did the trick.
Thank you all for your suggestions and help!
jc
-Original Message-
From: Jim Lyons [mailto:jlyons4...@gmail.com]
Sent: 07 May 2009 14:55
To: John Clement
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