Re: Access Denied

["Kenneth G. Arnold" <bkarnold () cbu edu>]

The information you want can be obtained as follows:

1.  Login to the mysql database as a user with sufficient rights to see
everything.  This is usually root but could be another user also.
2.  Issue the command "use mysql;".
3.  Issue the command "select * from user;"

The user table shows which users can login to the mysql databse from which
hosts.  If the permissions for this user/host combination are mostly Y,
that usually means that the user can access any database.  If the
permissions for this user are mostly N, that means that you need to look
in the table db for database specific permissions for the user/host
combination.

4. Issue the command "select * from db;"

Ken

On Thu, 6 Feb 2003, Anne Carasik wrote:

> Hi James,
>
> I'm not a mysql expert either, but here's what I ran into:
>
> Check your my.cnf file (or whatever mysql uses on Windows).
> See what it sets the password to. It defaults to "mypassword"
> on the UNIX mysql, so you'll need to remove it.
>
> -Anne
>
> Lucretia Enterprises grabbed a keyboard and typed...
> > Hi,
> >
> > I'm using Snort 1.9.0 configured with IDSCenter 1.1RC1 on two Windows2000sp3
> > machines, logging to a mysql 3.23.54 also on a Windows 2000sp3 box.
> >
> > I'm in the process of upgrading one snort sensor and adding another sensor.
> > I got both upgraded and ready to run (no errors), but when they attempt to
> > access the Mysql database, they get
> > "Access Denied"
> >
> > I'm lost as to why after an upgrade this would occur.  Yes, the password and
> > user ID are set up correctly. user=snort password=""
> > But I wonder, is there any way I can see who has access to the snort
> > database and confirm the settings?  I'm no Mysql guru...
> >
> > Thanks for your assistance,
> >
> > James.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.NET email is sponsored by:
> > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> > http://www.vasoftware.com
> > _______________________________________________
> > 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
>
> --
>               .-"".__."``".   Anne Carasik, System Administrator
>  .-.--. _...' (/)   (/)   ``'   gator at cacr dot caltech dot edu
> (O/ O) \-'      ` -="""=.    ',  Center for Advanced Computing Research
> ~`~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
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