- 论坛徽章:
- 0
|
我最近在windowxp下用mysql连接snort的脚本文件c:\snort\contrib\create-mysql,我在别处看的资料是这样:
建立snort 运行必须的snort 库和snort_archive 库
mysql>;create database snort;
mysql>;create database snort_archive;
使用c:\snort\contrib 目录下的create_mysql 脚本建立Snort 运行必须的数据表
c:\mysql\bin\mysql -D snort -u root -p < c:\snort\contrib\create_mysql
c:\mysql\bin\mysql -D snort_archive -u root -p < c:\snort\contrib\create_mysql
出现这样的错误:
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 56 to server version: 4.1.11-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>; mysql -D snort -u root -p < c:\snort\contrib\create_mysql;
--------------
D:\MySQL\bin\mysql.exe Ver 14.7 Distrib 4.1.11, for Win32 (ia32)
Connection id: 56
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 4.1.11-nt
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 4 hours 16 min 31 sec
Threads: 2 Questions: 410 Slow queries: 0 Opens: 54 Flush tables: 1 Open ta
bles: 0 Queries per second avg: 0.027
--------------
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 'reate
_mysql' at line 1
因为我刚学mysql4.1.11所以不知道什么原因,希望大家帮帮我,我先谢谢了。[/img] |
|