Oh, and yep I did flush privileges, and testdb wasn't actually the name of the db I was trying to create, the db I was trying to create didn't already exist. Thanks again for all the replies!
jc > -----Original Message----- > From: Ian Simpson [mailto:i...@it.myjobgroup.co.uk] > 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 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 Clement > > <john.clem...@readingroom.com>wrote: > > > > > 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 using > > > > > > grant all privileges on their_db.* to 'user'@'localhost' identified > by > > > 'pass'; > > > > > > If I try logging in as this user though the following happens: > > > > > > > > > > > > mysql> create database testdb; > > > ERROR 1044 (42000): Access denied for user 'user'@'localhost' to > > > database 'testdb' > > > > > > Can someone point out the error of my ways? > > > > > > Many thanks, jc > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > > > > > > > > > > -- > Ian Simpson > System Administrator > MyJobGroup > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.clem...@readingroom.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org