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 > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
