mysql>show grants for base@localhost;
mysql>show grants for snort@localhost;
8.設Mysql root 密碼
mysql>set password for root@localhost = password ("******"); #(內為密碼)為密碼
mysql>quit
9.開始->執行>cmd
cd \mysql\bin
c:\mysql \bin>mysql -u root -p密碼snort_log < c:\snort\schemas\create_mysql
c:\mysql \bin>mysql -u root -p密碼 snort_archive < c:\snort\schemas\create_mysql
再次登入看看資料欄位有無成功建立
c:\mysql\bin>mysql -u root -p
輸入密碼
mysql>use snort_log;
mysql>show tables; 查看一下
mysql>use snort_archive; mysql>show tables; 查看一下
10.設定MySQL安全性
mysql>drop database test;
mysql>use mysql;
mysql>delete from user where user='';
mysql>delete from user where user='%';
mysql>flush privileges;
11.安裝Apache Server
將安裝目錄設為c: 定選擇全部安裝 過程中出現防火牆請按解除封鎖
12.設定httpd.conf c:\Apache\conf\httpd.conf
增加這三行
LoadModule php5_module c:\php\php5apache2_2.dll
AddType application/x-httpd-php .php
PHPIniDir c:\php 存檔離開
13.安裝設定PHP
下載 http://www.php.net/downloads.php zip檔解壓縮至c:\php
設定php.ini 將C:\php\php.ini-dist 變更成php.ini
max_execution_time = 30改max_execution_time = 900
display_errors = On改display_errors = Off
extension_dir = "./"改extension_dir = "c:\php\ext"
; cgi.force_redirect = 1改cgi.force_redirect = 0
;extension=php_gd2.dll改extension=php_gd2.dll
;extension=php_mysql.dlle改xtension=php_mysql.dll
;extension=mbstring.dll改extension=mbstring.dll
;session.save_path = "/tmp"改session.save_path = "c:\windows\temp"
;include_path = ".;c:\php\includes"改include_path = "c:\php\pear" 重新啟動系統