Depends on how you added the privileges. If you used a grant <something>
statement then you don't have to flush privileges.

Anyway, to check what privileges a user has:

Connect to the mysql grants db as root or whatever and

show grants for userhost;

In your example, it would be:

show grants for snort192.168.0.1;

Also, just popped into my head. The error message you're receiving... are
you trying to connect to a database by the name of mysql instead of a
database named snort?

Steve

On Wed, Dec 04, 2002 at 10:22:26AM -0800, twig les wrote:
> A couple things to check first are:
> 1. can you log in remotely via the command-line (ie
> not thru snort)? Use "mysql -u [user] -h [serverIP]
> -p"
>
> 2. did you do a "flush privileges;" or restart the
> server after you added the privileges?
>
> 3. There is a command in mysql that pops up everyone's
> permissions and for the life of me I can't remember
> what it is. Ack. Now I'll be thinking about this all
> day.
>
> --- Zymophideth <zymophidethhotmail.com> wrote:
> > I'm following Steven J. Scott's Snort enterprise
> > Implementation v2.0 and I'm
> > running into some hang-ups. When I start snort I get
> > an error that says
> > "database: mysql: Access denied for user:
> > 'snort192.168.0.1' (Using
> > Password: YES) Fatal Error, Quitting...
> >
> > Seems like a permissions issue, but I put in the
> > accounts and all of that.
> > maybe I did it wrong? mysql daemon needs to be
> > restarted?
> >
> > I'm going off this manual word for word but it seems
> > like there are a few
> > flaws in it here and there. Anyone have experience
> > with it?
> >
> >
> >
> -------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft Visual
> > Studio.NET
> > comprehensive development tool, built to increase
> > your
> > productivity. Try a free online hosted session at:
> >
> http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
> > _______________________________________________
> > Snort-users mailing list
> > Snort-userslists.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
>
>
> =====
> -----------------------------------------------------------
> If you give a man a fish, he can eat for a day
> If you bludgeon him to death, you can eat the fish yourself
> -----------------------------------------------------------
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Microsoft Visual Studio.NET
> comprehensive development tool, built to increase your
> productivity. Try a free online hosted session at:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
> _______________________________________________
> Snort-users mailing list
> Snort-userslists.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

-------------------------------------------------------
This SF.net email is sponsored by: Microsoft Visual Studio.NET
comprehensive development tool, built to increase your
productivity. Try a free online hosted session at:
http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
_______________________________________________
Snort-users mailing list
Snort-userslists.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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]