problem logging to mysql database

[Omolayo Salako <OSalako () corp goamerica net>]

i have been running snort for a while now , having it  log to syslog and
using swatch to monitor stuff, i needed something more granular and
scalable. therefore i decided to use mysql database using both demarc and
acid and later decide on which one i prefer. I have demarc running o.k and
acid running fine. But i have consistenly had problem with mysql, i have
flushed privileges and recreated database manytimes to no avail. I am
running mysql and snort on a multihomed server. could the problem be that am
trying to access the database on localhost, Beacuse the error am getting is
something  like this " ACCESS DENIED, ACCESS FOR USER SNORT@LOCALHOST USING
PASSWORD YES FAILED. if so, since i only have one machine how do i access
the database from localhost or how does one go about solving this problem. i
have tried this statement in mysql GRANT ALL on snort.* to snort@my_domain
identified by password XXXXXX, it still did not work. Also when i try to log
in to demarc as anonymous i get the above error message, even though i have
edited the conf to allow anonmous user as admin. that makes me think my
problem is only with mysql. I plan to spend tonite reading MYSQL manual, but
any help you from the list would be greatly appreciated.


Molayo Salako.   CISSP
Network Security Engineer
Goamerica communications
E:osalako () corp goamerica net 

"imagination is more important than knowledge"   -Al Einstein 


_______________________________________________
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