4 messages in com.mysql.lists.win32Re: creatin users
FromSent OnAttachments
Ângelo M. Rigo25 Jun 2004 12:07 
SGr...@unimin.com25 Jun 2004 12:35 
Ângelo M. Rigo25 Jun 2004 12:54 
SGr...@unimin.com25 Jun 2004 13:06 
Subject:Re: creatin users
From:SGr...@unimin.com (SGr@unimin.com)
Date:06/25/2004 12:35:29 PM
List:com.mysql.lists.win32

It seems that YOU (Angelo) are not logged in to the server as an account with GRANT privileges. You are logged in as the "default user" and not as "root" or any other privileged account.

Regards, Shawn Green Database Administrator Unimin Corporation - Spruce Pine

"Ângelo M. Rigo" <angelomrigo@yaho To: win@lists.mysql.com o.com.br> cc: Fax to: 06/25/2004 04:08 Subject: creatin users PM

Hi

I am trying to create a user on my mysql, i do create direct on the table user using insert (Host, User, Password) values ('localhost', 'theuser', PASSWORD('xyvf')) and selecting the table this user is there having an encripted password.

Now i am trying to grant rigths but it fail, i type: grant all privileges on *.* to theuser@localhost identified by 'xyvf'; and get this message: Access denied for user: '@localhost' (Using password: NO)

What can be wrong?

Thanks in advance

--------------------------------- Crie seu Yahoo! Mail, agora com 100MB de espaço, anti-spam e antivírus grátis!