Thank you! That was it! Victor On Dec 20, 2007 9:20 PM, Moon's Father <[EMAIL PROTECTED]> 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 < [EMAIL PROTECTED]> 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 <[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 > > > > > > > > > > > > > > > > -- > I'm a mysql DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn
