[cobalt-users] MySQL not allowing "--skip-grant-tables" as root!

[Correllia Fuengabe <corras4@xxxxxxxxx>]

I have forgotten my MySQL root password.  Now that I 
need to add new databases, this is a problem.

I have found loadsd of instructions for resetting
these from the root account command line from an ssh 
connection to the RaQ4.  

Among others:
http://list.cobalt.com/pipermail/cobalt-users/2001-March/036744.html

However, following the instrructions here & elsewhere 
including:
http://www.mysql.com/doc/P/r/Privileges_options.html 
I have a real problem after killing all the running
mysqld services:

the command:
ps -A | grep sql
lists nothing, so MySQL is down.

I then get this:
------------------------------------
[root admin]# /usr/sbin/mysqld --skip-grant-tables
Fatal error: Please read "Security" section of the
manual to find out how to run mysqld as root!
020502  3:10:35  Aborting

020502  3:10:35  /usr/sbin/mysqld: Shutdown Complete
------------------------------------

Any advice or ideas?!?!?

Thanks!



__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com