RE: DB ERROR

["Luo, Philip" <Philip_Luo () adp com>]

There is no error when I tried mysql -u snort -p snort,
Then I tried the rest, here is what I got,

mysql> show grants for snort@localhost;
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| Grants for snort@localhost
                                                     |
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'snort'@'
localhost' IDENTIFIED BY PASSWORD '1e6b29186dd45e97' |
| GRANT SELECT, INSERT, DELETE, CREATE ON `snort`.* TO 'snort'@'localhost'
                                                     |
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show grants for snort@127.0.0.1;
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| Grants for snort@127.0.0.1
                                                     |
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'snort'@'
127.0.0.1' IDENTIFIED BY PASSWORD '1e6b29186dd45e97' |
| GRANT SELECT, INSERT, DELETE, CREATE ON `snort`.* TO 'snort'@'127.0.0.1'
                                                     |
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
2 rows in set (0.00 sec)


-----Original Message-----
From: Steve Suehring [mailto:snort () braingia org] 
Sent: Friday, December 13, 2002 10:13 AM
To: Luo, Philip
Cc: snort-users () lists sourceforge net
Subject: Re: [Snort-users] DB ERROR

Can you try doing something like this from the command-line:

mysql -u snort -p snort

Then see what error and/or error number you get.

Also, from with the MySQL CLI (as root):
show grants for snort@localhost;
show grants for snort@127.0.0.1;

Steve

On Fri, Dec 13, 2002 at 09:20:46AM -0500, Luo, Philip wrote:
> I did, no luck. I modifies the hosts file too.
>
> -----Original Message-----
> From: Jens Krabbenhoeft [mailto:tschenz-snort-users () noris net] 
> Sent: Thursday, December 12, 2002 11:36 AM
> To: snort-users () lists sourceforge net
> Subject: Re: [Snort-users] DB ERROR
>
> Hi,
>
> > grant INSERT,SELECT,CREATE,DELETE on snort.* to snort@localhost
identified
>                                                         ^^^^^^^^^
> > Database ERROR:Database ERROR:Access denied for user: 'snort@127.0.0.1'
to
>                                                                ^^^^^^^^^
>
> Try doing a grant for snort@127.0.0.1
>
> HTH,
>       Jens 
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:
> With Great Power, Comes Great Responsibility 
> Learn to use your power at OSDN's High Performance Computing Channel
> http://hpc.devchannel.org/
> _______________________________________________
> 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:
> With Great Power, Comes Great Responsibility 
> Learn to use your power at OSDN's High Performance Computing Channel
> http://hpc.devchannel.org/
> _______________________________________________
> 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:
With Great Power, Comes Great Responsibility 
Learn to use your power at OSDN's High Performance Computing Channel
http://hpc.devchannel.org/
_______________________________________________
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