162

Chapter 5     Using Snort with MySQL

to access this database. Assuming MySQL server is running on  localhost, a typical

mysql session to create the database and check its status is as follows:

[root@laptop]# mysql  h localhost  u root  p   

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 40 to server version: 3.23.36

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

mysql> create database snort;

Query OK, 1 row affected (0.00 sec)

mysql> use snort

Database changed

mysql> status

mysql  Ver 11.13 Distrib 3.23.36, for redhat linux gnu (i386)

Connection id:

41

Current database:

snort

Current user:

root@localhost

Current pager:

stdout

Using outfile:

Server version:

3.23.36

Protocol version:

10

Connection:

Localhost via UNIX socket

Client characterset:

latin1

Server characterset:

latin1

UNIX socket:

/var/lib/mysql/mysql.sock

Uptime:

1 hour 56 min 29 sec

Threads: 1  Questions: 107  Slow queries: 0  Opens: 14  Flush 

tables: 1  Open tables: 7 Queries per second avg: 0.015

mysql>

The following commands are used in this session:

  The command  mysql  h localhost  u root  p   is used to connect

mysql client to a database server running on localhost. The   u root 

part shows the database user name used to connect to the database. The   p 

part is used to enter user password on the next line. A welcome message is

displayed after login and you get the  mysql>  prompt where you can issue

other commands.