[Snort-users] SQL trouble

Kevin.Brown at ...1022... Kevin.Brown at ...1022...
Fri Jan 12 19:07:16 EST 2001

> heh...  I had a bit of a fun time of that late last week. :)
> > Now I try to do the rest of the steps on incident.org/snortdb and get to step
> > 5 regarding building the structure of the database.  I'm in the snort-1.7
> > directory so I do "mysql < ./contrib/create_mysql" and it spits back "ERROR
> > 1045: Access denied for user: 'root at ...274...' (Using password: NO)", ok so I
> > try "mysql -u root -p < ./contrib/create_mysql", it prompts me for roots
> > password and I give it the one I setup for MySQL (not the system password) and
> > it spits back "ERROR 1046 at line 21: No Database Selected".  
> > 
> > I understand that this is a MySQL issue and not a snort issue, but I tried
> > searching the MySQL site for these errors and didn't find anything.  Does
> > anyone see what I did wrong.
> Well...  I'm not sure if it's the 'right way(tm)', but I happened to get it to
> work by using "/path/to/mysql -u snort -p snort < ./contrib/create_mysql".  
> BTW, did you give the user privs on that table?  I used "grant INSERT,SELECT
> on snort.* to snort at ...274...".  

That was another step I was confused on.  I ended up doing 'echo "grant
INSERT,SELECT on snort.* to snortdb at ...274..." | mysql -u root -p'  is this
part correct?

More information about the Snort-users mailing list