Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Victor Subervi (victorsubervigmail.com)
Date: Thu Dec 20 2007 - 12:00:38 CST
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
On Dec 20, 2007 1:49 PM, Amit Sharma <amitsharmaaffle.co.uk> wrote:
> My guess: The user could already be there. Is this a fresh DB, can you
> the server logs for more info?
> Amit Sharma
> E: amitsharmaaffle.co.uk
> M: +91 9971 490 700
> W: www.affle.co.uk
> > -----Original Message-----
> > From: Victor Subervi [mailto:victorsubervigmail.com]
> > Sent: 20 December 2007 22:57
> > To: mysqllists.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