Snort mailing list archives
RE: putting mysql on a different computer with windows
From: "Hutchinson, Andrew" <Andrew.Hutchinson () Vanderbilt edu>
Date: Fri, 18 Jan 2002 09:10:20 -0600
Your syntax looks good. The privileges are listed in the db table, not the user table. Do a: SELECT * FROM db and you should see the user that you created and the appropriate permissions. Have you tried to do a FLUSH PRIVILEGES to reload the grant tables? Give this a try and see if it works. Andrew Hutchinson CNE MCSE Informatics/NCS/Network Security Vanderbilt University Medical Center 615.936.2856 - voice 615.936.0643 - fax andrew.hutchinson () mcmail vanderbilt edu -----Original Message----- From: Jeffrey Post [mailto:jpost () edc org] Sent: Thursday, January 17, 2002 8:18 PM To: snort-users () lists sourceforge net Subject: [Snort-users] putting mysql on a different computer with windows Hello, I am currently running Snort 1.8 with mysql and acid all on one computer running windows NT server. If I put mysql on another server when I start snort I always get an error when it tries to access the database on the remote computer. I have changed my output line to the ip address of the new server so I have output database: log, mysql, username=<username> password=<password> dbnam=snort host=xxx.xxx.xxx.xxx the error is mysql error access denied for user <username>@ip address using password: YES I am assuming the YES stands for it is trying to use a password, not that the password is YES (which would be incorrect.) If I go into mysql and issue a grant INSERT,SELECT,CREATE,DELETE on snort.* to <username>@ipaddress mysql will put <username>@ipaddress in the user table if I select * from user then it show <username>@ipaddress with n in every entry. I am assuming this means it really hasn't been granted access. Does anyone know what I am doing wrong? Thanks, Jeff _______________________________________________ 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 _______________________________________________ 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:
- putting mysql on a different computer with windows Jeffrey Post (Jan 17)
- Re: putting mysql on a different computer with windows Greg Robinson (Jan 18)
- <Possible follow-ups>
- RE: putting mysql on a different computer with windows Hutchinson, Andrew (Jan 18)