MySQL Forums
Forum List  »  Newbie

Re: problem using user accounts
Posted by: Ramalingam Chelliah
Date: August 16, 2004 12:23AM

Hi,
You have enabled user 'bntdb' to access your database from "%"
(any host) but not localhost...

You have to do this like

grant all on blacknova.* to bntdb@'localhost' identified by 'bntdb';

The reason why you are let without password may be a result of

allowing anonymous login ...
( any user can login without password)

mysql > Select user,host,password
from mysql.user ;

Do you see rows with "blank" user name ,host and password ?
(Anonymous login)

Also Check whether 'bntdb' is allowed in localhost

mysql> select user,host,password
from user
where host="loalhost" or host="";

Hope this helps,
Still getting error ?

Regards,
Ram.



Options: ReplyQuote


Subject
Written By
Posted
August 11, 2004 04:19PM
August 13, 2004 07:40AM
Re: problem using user accounts
August 16, 2004 12:23AM
August 17, 2004 09:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.