为snort引导mysqlcreate建表脚本

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:/Documents and Settings/Administrator>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 2 to server version: 5.0.22-community-nt

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql> creat database snort;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'creat
 database snort' at line 1
mysql> create database snort
    -> ;
Query OK, 1 row affected (0.03 sec)

mysql> grant all on snort.* to  snort@'localhost' identified by 'legend';
Query OK, 0 rows affected (0.03 sec)

mysql> quit
Bye

C:/Documents and Settings/Administrator>mysql -u root -p snort<c:/create_mysql
Enter password: ******

C:/Documents and Settings/Administrator>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 4 to server version: 5.0.22-community-nt

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql> use snort;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_snort |
+-----------------+
| data            |
| detail          |
| encoding        |
| event           |
| icmphdr         |
| iphdr           |
| opt             |
| sensor          |
| tcphdr          |
| udphdr          |
+-----------------+
10 rows in set (0.03 sec)

mysql>