My guess: The user could already be there. Is this a fresh DB, can you check the server logs for more info?
Regards, Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk > -----Original Message----- > From: Victor Subervi [mailto:[EMAIL PROTECTED] > Sent: 20 December 2007 22:57 > To: mysql@lists.mysql.com > Subject: Problems Adding User > > Hi; > > I can create the following just fine: > > grant all on data1.* to myuser IDENTIFIED BY 'pass'; > > grant all on data2.* to myuser IDENTIFIED BY 'pass'; > > ...but when I try this: > > CREATE USER myuser IDENTIFIED BY 'pass'; > > ERROR 1396 (HY000): Operation CREATE USER failed for 'myuser'@'%' > > ...and this: > > 1044, "Access denied for user 'myuser'@'%' to database 'data1'" > > Why? > > TIA, > > Victor > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
