On Tue, Nov 15, 2011 at 9:20 PM, Steven Jones <[email protected]> wrote:
> Hi,
>
> Looking at the wiki
>
> http://www.ossec.net/wiki/Know_How:DatabaseOutput#Create_a_user_for_OSSEC
>
> and configuring mysql,
>
> I think there is a line missing, or at least comment that it might be needed
>
> eg.,
>
> CREATE USER 'ossecuser'@'localhost' IDENTIFIED BY 'ossecpass';
>
This doesn't create the user and set the password (I don't use mysql
if I can help it):
mysql> grant INSERT,SELECT,UPDATE,CREATE,DELETE,EXECUTE on ossec.* to
ossecuser@<ossec ip>;
Query OK, 0 rows affected (0.00 sec)
mysql> set password for ossecuser@<ossec ip>=PASSWORD('ossecpass');
Query OK, 0 rows affected (0.00 sec)
> before creating the database I suggest.
>
>
> regards
>
> Steven Jones
>
> Technical Specialist - Linux RHCE
>
> Victoria University, Wellington, NZ
>
> 0064 4 463 6272
