Re: problem using user accounts
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.
Subject
Written By
Posted
Re: problem using user accounts
August 16, 2004 12:23AM
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.