Newbie Database + Snort

[Peter Bates <peter.bates () lshtm ac uk>]

Hello all...

I've been testing snort 1.8.1 and all seems fine,
but I'm just trying to get my trusty 1.7 system
working with MySQL so I can try out/use ACID.

Being relatively new to the world of MySQL,
I've set the system up (this is on RH Linux 7.1)
and can connect as root to the DB server

# mysqlshow -p
Enter password:
+-----------+
| Databases |
+-----------+
| mysql     |
| snort     |
| test      |
+-----------+

I appear to have done the
grant INSERT,SELECT on snort.* to snort@localhost;

But when I try mysqlshow or mysql as the snort user, I get:

bash-2.04$ mysqlshow snort
mysqlshow: Access denied for user: '@localhost' to database 'snort'

So naturally attempting to run contrib/create_mysql
is failing dismally...

Can anyone tell me what I'm doing wrong?


Thanks...

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
http://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users