I have a debian sarge 3.1 and i have installed snort oinkmaster and mysql.I would like to collect snort data allerts in php format.I'm very bad in mysql and i'm reading a mysql guide about this issue .
I have created a database snort as the guide says ...
Code:
root@www:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 705 to server version: 4.0.24_Debian-10sarge2-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database snort;
Query OK, 1 row affected (0.05 sec)
mysql> connect snort;
Connection id: 706
Current database: snort
mysql> status;
--------------
mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
Connection id: 706
Current database: snort
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.24_Debian-10sarge2-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 1 day 9 hours 51 min 23 sec
Threads: 1 Questions: 12780 Slow queries: 0 Opens: 226 Flush tables: 1 Open tables: 59 Queries per second avg: 0.105
--------------
mysql> grant CREATE,INSERT,SELECT,DELETE,UPDATE on snort.* to root@localhost;
ERROR 1146: Table 'mysql.user' doesn't exist
mysql> grant CREATE,INSERT,SELECT,DELETE,UPDATE on root.* to root@localhost;
ERROR 1146: Table 'mysql.user' doesn't exist
What is this guide trying to say to me with the grant command ?Why this error?Should i have to create a table ?The guide doesn't say to do it.
Thanks!