Setting Password for root while configuring mySQL

[santosh bethi <santoshbethi1 () yahoo co in>]

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

This is the error I am getting. I am using the mysql
package that comes with Red hat 9 and I changed the
local host name to 'subha' using the hostname command.
I used the hostname I set.
Please help out.



________________________________________________________________________
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com


-------------------------------------------------------
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