[Snort-users] mysql_error: Access denied for user: 'snort at ...7159...' (Using password: YES)
sujit.pal at ...3147...
Sat Oct 12 10:11:08 EDT 2002
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
Steve your answer gives me insight to other aspects which will be useful
later. I thank you again for your reply.
From: Steve Suehring [mailto:snort at ...7160...]
Sent: Saturday, October 12, 2002 12:47 PM
To: Sujit Pal
Subject: Re: [Snort-users] mysql_error: Access denied for user:
'snort at ...7159...' (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 at ...7159... which is my client system
> Where is the command taking the PASSWORD YES from.
> database: mysql_error: Access denied for user: 'snort at ...7159...' (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 at ...3360... and password. So, in other words, there needs to be
specific grants for snort at ...274..., snort at ...7161...,
snort at ...7159..., 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 at ...7159...;
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!
More information about the Snort-users