[Snort-users] putting mysql on a different computer with windows
Andrew.Hutchinson at ...3639...
Fri Jan 18 07:11:11 EST 2002
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
Vanderbilt University Medical Center
615.936.2856 - voice
615.936.0643 - fax
andrew.hutchinson at ...3295...
From: Jeffrey Post [mailto:jpost at ...3843...]
Sent: Thursday, January 17, 2002 8:18 PM
To: snort-users at lists.sourceforge.net
Subject: [Snort-users] putting mysql on a different computer with
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>
the error is
mysql error access denied for user <username>@ip address using password:
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?
Snort-users mailing list
Snort-users at lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
Snort-users list archive:
More information about the Snort-users