Re: Database permissions question

[Erek Adams <erek () snort org>]

On Sun, 22 Jun 2003, John Deagan wrote:

> database: compiled support for ( mysql )
> database: configured to use mysql
> database:          user = root
> database: password is set
> database: database name = snorttest1
> database:          host = *****
> database:   sensor name = unknown:[reading from a file]
> database: mysql_error: Host '*****' is not allowed to connect
> to this MySQL server
>
> Ive got a database on one machine, and snort on another, and now Im having
> programs running snort.  Its saying its not allowed to connect, so are there
> some permissions I have to change?

Ok, I'm teetering on the brink of a rant, but I'm going to try to come
back from the edge--And no, it's not at anyone in particular....

Check the FAQ [0], the ACID FAQ [1], and the archives [2].  It's been
spelled out there more times than I would care to count.

You have the permissions set for one user and are trying to access MySQL
with another user.  Make sure that you have both the username and host
correct and make sure that the correct user@host has permissions to the
DB.

Oh, and 2 penalty drinks [3].

Cheers!

-----
Erek Adams

   "When things get weird, the weird turn pro."   H.S. Thompson


[0]     http://www.snort.org/docs/FAQ.txt
[1]     http://www.andrew.cmu.edu/~rdanyliw/snort/acid_faq.html
[2]     http://marc.theaimsgroup.com/?l=snort-users&r=1&w=2
[3]     http://www.theadamsfamily.net/~erek/snort/drinking_game.txt


-------------------------------------------------------
This SF.Net email is sponsored by: INetU
Attention Web Developers & Consultants: Become An INetU Hosting Partner.
Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users