[Snort-users] Acid / MySQL question

dan.forthun at ...2897... dan.forthun at ...2897...
Thu Nov 8 08:37:06 EST 2001

I do

mysql> grant insert,select on snort.* to remoteuserid at ...4033... identified by 'remotepasswd'

Lance Spitzner <lance at ...2024...>@lists.sourceforge.net on 11/08/2001 08:56:21 AM

Sent by:  snort-users-admin at lists.sourceforge.net

To:     "Snort-Users (E-mail)" <snort-users at lists.sourceforge.net>
cc:      (bcc: Dan Forthun/ABQ/SC/PHILIPS)
Subject:  [Snort-users] Acid / MySQL question

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

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?


Lance Spitzner

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 mailing list