Making Snort Work with MySQL

163

  The command  create database snort;  creates a new database in the

MySQL server with the name  snort . You can use any name of your choice

for the database.

  The   use snort  command is used to start using the newly created database.

  The   status  command shows current status of the database server. It shows

that the currently opened database is  snort. 

To end the mysql client session, you can use the  exit  command at the

MySQL prompt.

5.1.4

Step 4: Creating MySQL User and Granting Permissions to 

User and Setting Password

Using the database user root to access the Snort database is not recommended.

For this purpose, you will create a new user  rr . The next command creates a user

with name rr. The same command also grants the following permissions to all tables in

the snort database we recently created.

  CREATE, used to create new objects

  INSERT, used to insert data into the database

  DELETE, used to delete data from the database

  UPDATE, used to modify records

  SELECT, used to display and select records

We shall use this user to access the Snort database. This user name and password

are also used in the snort.conf file when you configure output database module.

mysql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on snort.* to 

rr@localhost;

Query OK, 0 rows affected (0.00 sec)

mysql> 

The permission for this newly created user is granted only for the database Snort.

A single command creates the user and grants permission.

Now you need to assign a password to this user. The following command assigns a

password  rr78x  to this user.

mysql> set password for rr = password( rr78x );

Query OK, 0 rows affected (0.00 sec)

mysql>