Re: Acid / MySQL question

[dan.forthun () philips com]

I do

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




Lance Spitzner <lance () honeynet org>@lists.sourceforge.net on 11/08/2001 08:56:21 AM

Sent by:  snort-users-admin () lists sourceforge net


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



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





_______________________________________________
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