HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials - View Single Post - SNORT and BASE on a CLEAN "The Perfect Setup

StupidScript · #5 19th July 2006, 07:11

Quote:

There are many ways to create the snort database.

For MySQL:

Code:

cd /root/snorttemp/schemas

Code:

mysql -u MASTERUSER -pMASTERPASSWORD

Code:

mysql>create database snortdb;

Code:

mysql>use snortdb;

Code:

mysql>source create_mysql;

Code:

mysql>grant all on snortdb.* to snortuser@localhost identified by 'snortpassword';

Code:

mysql>quit;

That will use the installed sql file to populate the default 'snortdb' database and add the proper permissions for the 'snortuser' of your choice with the 'snortpassword' of your choice.

FYI.