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

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: amitsharma@affle.co.uk
M: +91 9971 490 700
W: www.affle.co.uk

> -----Original Message-----
> From: Victor Subervi [mailto:victorsubervi@gmail.com]
> 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
>

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 <amitsharma@affle.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: amitsharma@affle.co.uk
> M: +91 9971 490 700
> W: www.affle.co.uk
>
> > -----Original Message-----
> > From: Victor Subervi [mailto:victorsubervi@gmail.com]
> > 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
> >
>
>

Thank you! That was it!
Victor

On Dec 20, 2007 9:20 PM, Moon's Father <yueliangdao0608@gmail.com> wrote:

> You forgot to enter the command flush privileges after your creating user.
> The try on my mathine is as follows:
> mysql> create user 'mail_list'@'localhost' identified by '1234656';
> Query OK, 0 rows affected ( 0.00 sec)
>
> mysql> flush privileges;
> Query OK, 0 rows affected (0.00 sec)
>
> The user I created before works right once.
>
>
>
> On Dec 21, 2007 2:00 AM, Victor Subervi < victorsubervi@gmail.com> wrote:
>
> > 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 <amitsharma@affle.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: amitsharma@affle.co.uk
> > > M: +91 9971 490 700
> > > W: www.affle.co.uk
> > >
> > > > -----Original Message-----
> > > > From: Victor Subervi [mailto:victorsubervi@gmail.com ]
> > > > 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
> > > >
> > >
> > >
> >
>
>
>
> --
> I'm a mysql DBA in china.
> More about me just visit here:
> http://yueliangdao0608.cublog.cn