mysql error

["Atkins, Dwane P" <ATKINSD () uthscsa edu>]

I am trying to install snort on a device. And when I run the snort -c
/etc/snort/snort.conf, I receive the ERROR: database: mysql_error:
Access denied for user 'snort'@'localhost' (using password: YES) Fatal
Error, Quitting..

 

I can log into mysql using the snort login.  I have entered the
following commands:

 

grant INSERT,SELECT on root.* to snort@localhost; SET PASSWORD FOR 
snort@localhost=PASSWORD('********');
grant CREATE,INSERT,SELECT,DELETE,UPDATE on snort.* to snort@localhost; 
grant CREATE,INSERT,SELECT,DELETE,UPDATE on snort.* to snort; 
 
I seem to recall that there was a way to clear permissions in mysql. But
I cannot remember the commands. 
 
Any help would be appreciate.
 
Dwane 

<mailto:atkinsd () uthscsa edu>  

 

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/

_______________________________________________
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