[Snort-users] SQL trouble

Jason Boyer jason at ...418...
Wed Jan 17 11:45:16 EST 2001


Kevin,

This should work for you
mysql -D snort -u root -p< create_mysql

Cheers,
Jason

Kevin.Brown at ...1022... wrote:

> Sorry for the delay in responding.  I didn't get back to work until today.  I
> did grant the user the insert and select privileges, and created the
> database.  The problem seems to be with the script (at least on my
> system).  doing:
>
> # mysql -u root -p < ./contrib/create_mysql
>
> results in the error saying that No database was selected.  So how do I tell
> it which database to do those commands on?
>
> > > > 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".
> >
> > Also, don't forget to create the snort database first.
> >
> >   % echo "CREATE DATABASE snort;" | mysql -u root -p
> >
> > * Jed
> >
>
> _______________________________________________
> Snort-users mailing list
> Snort-users at lists.sourceforge.net
> Go to this URL to change user options or unsubscribe:
> http://lists.sourceforge.net/lists/listinfo/snort-users





More information about the Snort-users mailing list