构建基于Windows+MySQL+Apache+php+Snort的IDS
安装目录下运行，即c:\mysql\bin>mysql -u root -p） 10、利用以下语句在mysql中建立snort 运行必须的snort 库和snort_archive 库mysql>create database snort;
mysql>create database snort_archive;
11、利用以下语句为Mysql 建立snort 和acid 帐号，使IDSCenter或acid能正常访问Mysql中与snort相关的数据文件
mysql> grant usage on *.* to "acid"@"localhost">
mysql> grant usage on *.* to "snort"@"localhost"> 12、利用以下语句为acid拥护和snort 拥护设置密码
mysql>set password for "acid"@"localhost" = password('123');
mysql>set password for "snort"@"localhost" = password('123');
13、利用以下语句为acid 用户和snort 用户分配相关权限
mysql> grant select,insert,update,delete,create,alter on snort .* to "acid"@"localhost";
mysql> grant select,insert,update,delete,create,alter on snort_archive .* to "acid"@"localhost";
mysql> grant select,insert,update,delete,create,alter on snort .* to "snort"@"localhost";
mysql> grant select,insert,update,delete,create,alter on snort_archive .* to "snort"@"localhost";
（注意：以上四个步骤的任务可以利用以脚本来完成，具体的方法是——在C盘创建一个脚本文件snort_mysql内容如下：
################################################################################
create database snort;
create database snort_archive;
grant usage on *.* to "acid"@"localhost">
grant usage on *.* to "snort"@"localhost"> set password for "acid"@"localhost" = password('123');
set password for "snort"@"localhost" = password('123');
grant select,insert,update,delete,create,alter on snort .* to "acid"@"localhost";
grant select,insert,update,delete,create,alter on snort_archive .* to "acid"@"localhost";
grant select,insert,update,delete,create,alter on snort .* to "snort"@"localhost";
grant select,insert,update,delete,create,alter on snort_archive .* to "acid"@"localhost";
#################################################################################
然后c:\>mysql -D mysql -u root -p < c:\snort_mysql）
14、利用以下语句，使用c:\snort\schemas目录下的create_mysql脚本分别在新建的库中建立Snort运行必须的数据表
c:\mysql\bin\mysql -D snort -u root -p < c:\snort\schemas\create_mysql
c:\mysql\bin\mysql -D snort_archive -u root -p < c:\snort\schemas\create_mysql
（或是将C:\Snort\schemas下的create_mysql文件拷贝到C:\mysql5\bin目录下后，分别在snort和snort_archive库中执行mysql>source
页:
[1]