Acid / MySQL question

[Lance Spitzner <lance () honeynet org>]

Okay, I'm going over the MySQL manual and my head is ready
to explode, I be database ignorant.  Question.

  "How do I create seperate mysql accounts for each
   one of my Snort sensors feeding data to the ACID
   database?"

I have 5 remote Snort sensors I want to feed data to my
backend ACID/MySQL database.  To do this, I have to add
the mysql user account and password to each snort.conf file
so each Snort sensor can send alerts to the database.

output database: log, mysql, user=root password=test dbname=db host=localhost

For security reasons, I want each sensor to have a unique
user account and password on the mysql database.  I feel user
root is a bad thing, as this is full privalleges on the mysql
database.  So what is the >mysql command systax to add seperate
users and passwords so each sensor has privalleges to add data to
the snort database?

Thanks!

-- 
Lance Spitzner
http://project.honeynet.org


_______________________________________________
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