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>






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

toronto web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved