Re: Access Denied when logging to MySQL database

[Steve Suehring <snort () braingia org>]

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 user@host;

In your example, it would be:

show grants for snort@192.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 <zymophideth () hotmail 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:
> > 'snort@192.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-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
>
>
> =====
> -----------------------------------------------------------
> 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-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


-------------------------------------------------------
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-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