Snort mailing list archives
RE: mysql_error: Access denied for user: 'snort@192.168.1.30' (Using password: YES)
From: "Sujit Pal" <sujit.pal () verizon net>
Date: Sat, 12 Oct 2002 13:07:59 -0400
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=123qweiam 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
Current thread:
- mysql_error: Access denied for user: 'snort@192.168.1.30' (Using password: YES) Sujit Pal (Oct 12)
- Re: mysql_error: Access denied for user: 'snort@192.168.1.30' (Using password: YES) Robby Desmond (Oct 12)
- <Possible follow-ups>
- RE: mysql_error: Access denied for user: 'snort@192.168.1.30' (Using password: YES) Sujit Pal (Oct 12)