You're right and I should have thought that through. This is a new build on a new server with an imported dump, and of course that data was conserved. However, why doesn't it let me connect to the databases? I've entered as the root user, and granted the priviledges, as in my previous email, and there are two databases I cannot access. Interestingly, there is a third database I can access, and I granted priviledges the exact same way! What could I be doing wrong? TIA, Victor
On Dec 20, 2007 1:49 PM, Amit Sharma <[EMAIL PROTECTED]> wrote: > 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 > > > >
