That´s it i log in inside bin directory with mysql --user=root and the grant query works

SGr...@unimin.com wrote:

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" 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