RE: Setting Password for root while configuring mySQL

["Schmehl, Paul L" <pauls () utdallas edu>]

> -----Original Message-----
> From: snort-users-admin () lists sourceforge net 
> [mailto:snort-users-admin () lists sourceforge net] On Behalf Of 
> santosh bethi
> Sent: Tuesday, November 11, 2003 2:00 AM
> To: snort-users () lists sourceforge net
> Subject: [Snort-users] Setting Password for root while 
> configuring mySQL
>
> While setting up the database in mySQL for snort, we
> have to type:
> SET PASSWORD FOR root@subha=PASSWORD('passwd');
> ERROR 1133: Can't find any matching row in the user
> table
Put spaces around the = sign.

SET PASSWORD FOR root@subha = PASSWORD('passwd');

Or, if you're already logged in as root:

SET PASSWORD = PASSWORD('passwd');

Paul Schmehl (pauls () utdallas edu)
Adjunct Information Security Officer
The University of Texas at Dallas
AVIEN Founding Member
http://www.utdallas.edu/~pauls/ 


-------------------------------------------------------
This SF.Net email sponsored by: ApacheCon 2003,
16-19 November in Las Vegas. Learn firsthand the latest
developments in Apache, PHP, Perl, XML, Java, MySQL,
WebDAV, and more! http://www.apachecon.com/
_______________________________________________
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