RE: (Snort-users) multiple snorts to 1 mysql database

["Hawk X" <huhawk () hotmail com>]

another approach would be:

mysql> grant all privileges on snort.* to snort () host domain com identified
by 'NOT';

the syntax is like:
GRANT ALL PRIVILEGES on 'database'.'tables' to 'user'@'host' identified by
'password';

and yes, you can use wildcards in 'host' and 'user' :
GRANT ALL PRIVILEGES on mydb.* to 'mydb_user'@'%' identified by
'guesswhat';
it gives all priv. to user mydb_user connecting from any machine (use with
caution!) with password 'guesswhat'

Of course snort database plugin doesn't need all privileges, SELECT and
INSERT are enough. I highly recommend typing 'info mysql' at your *nix
prompt, 'cos the docs are really well maintained, and you could find
almost everything under *REFERENCES.

Sincerely
       Gergely Szilagyi
       LAN/WAN APPLICATIONS
       email: gergely () szilagyi org



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


_______________________________________________
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