四.在mysql中建立数据库
/usr/local/mysql/bin/mysql
mysql>SET PASSWORD FOR root@localhost=PASSWORD(’your_password’);
mysql>create database snort;
mysql>grant INSERT,SELECT on root.* to snort@localhost;
mysql>quit;
进入snort安装目录：/usr/local/mysql/bin/mysql -p
gt;Enter password:
安装DB表：(在contrib目录）
zcat snortdb-extra.gz /usr/local/mysql/bin/mysql -p snort
进入mysql数据库，看看snort数据库中的表：
/usr/local/mysql/bin/mysql -p
gt;Enter password:
mysql>show databases;
+————+
Database
+————+
mysql
snort
test
+————+
3 rows in set (0.00 sec)
mysql>use snort;
mysql>show tables; 将会有这些：
+——————+
Tables_in_snort
+——————+
data
detail
encoding
event
flags
icmphdr
iphdr
opt
protocols
reference
reference_system
schema
sensor
services
sig_class
sig_reference
signature
tcphdr
udphdr
+——————+
19 rows in set (0.00 sec)
mysql>exit
