From: Victor Subervi (victorsubervigmail.com)
Date: Thu Dec 20 2007 - 12:00:38 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <amitsharmaaffle.co.uk> 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: 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
> >
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]