RE: mysql_error: Access denied for user: 'snort@192.168.1.30' (Using password: YES)

["Sujit Pal" <sujit.pal () verizon net>]

Thanks , Steve.

I banged my head on this some more and finally figured out the problem. It
was my error. In the snort.conf file i was putting the password in between
quotes.

Steve your answer gives me insight to other aspects which will be useful
later. I thank you again for your reply.

Regards.




-----Original Message-----
From: Steve Suehring [mailto:snort () braingia org]
Sent: Saturday, October 12, 2002 12:47 PM
To: Sujit Pal
Subject: Re: [Snort-users] mysql_error: Access denied for user:
'snort@192.168.1.30' (Using password: YES)


On Sat, Oct 12, 2002 at 11:38:20AM -0400, Sujit Pal wrote:
> > mysql --host=192.168.1.55 --user=snort --password=123qwe
> iam able to access the database and see tables etc.

> Do I need to give grants for snort@192.168.1.30 which is my client system
.
> Where is the command taking the PASSWORD YES from.

> database: mysql_error: Access denied for user: 'snort@192.168.1.30' (Using
> password: YES)
> Fatal Error, Quitting..

I can't answer question #1, but I think I can help with this one.  For
some reason, there aren't grants for user snort located at 192.168.1.30
with the password specified.  MySQL authenticates based on
username@hostname and password.  So, in other words, there needs to be
specific grants for snort@localhost, snort@192.168.1.N,
snort@192.168.1.30, and so on.  With that said, there could be a number of
reasons for an authentication failure including, but not limited to,
simply a mistyped password.

On your MySQL server, you should be able to connect to the 'mysql' grants
database (mysql -u root -p mysql) and do a:

SHOW GRANTS FOR snort@192.168.1.30;

That should show the privileges for the snort user.

In regards to the "(Using password: YES)" portion of the error, this
simply means that it attempted to connect with a password, as opposed to
not using a password at all.

Hope this info helps!

Steve Suehring





-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users