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=arch...@jab.org
