[Snort-users] DB ERROR

Luo, Philip Philip_Luo at ...4729...
Mon Dec 16 05:44:02 EST 2002


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 at ...274...;
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| Grants for snort at ...274...
                                                     |
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| 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 at ...263...;
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| Grants for snort at ...263...
                                                     |
+---------------------------------------------------------------------------
----
-----------------------------------------------------+
| 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 at ...7160...] 
Sent: Friday, December 13, 2002 10:13 AM
To: Luo, Philip
Cc: snort-users at 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 at ...274...;
show grants for snort at ...263...;

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 at ...7018...] 
> Sent: Thursday, December 12, 2002 11:36 AM
> To: snort-users at lists.sourceforge.net
> Subject: Re: [Snort-users] DB ERROR
> 
> Hi,
> 
> > grant INSERT,SELECT,CREATE,DELETE on snort.* to snort at ...274...
identified
>                                                         ^^^^^^^^^
> > Database ERROR:Database ERROR:Access denied for user: 'snort at ...263...'
to
>                                                                ^^^^^^^^^
> 
> Try doing a grant for snort at ...263...
> 
> 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 at 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 at 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





More information about the Snort-users mailing list