Re: [cobalt-users] RaQ4 MySQL Lost root password

[James Riordon <cobalt@xxxxxxxxxx>]

At 16:50 -0400 09/06/2001, James Riordon was thought to have said :


> I lost the root password for MySQL.
>
> i have followed the howto's in hte archive but they don't seem to 
> work for me. I first of all did :
>
> /etc/rc.d/init.d/mysql stop
>
> Then I did 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!
> 010906 16:39:09  Aborting
>
> 010906 16:39:09  /usr/sbin/mysqld: Shutdown Complete
>
> [root admin]#
>
> what am i doing wrong? I really need the access back now.


As usual, I work on solving the problem for 2.5 hours and nothing. I 
submit to the list for help and within 5 minutes i find the answer. 
Thanks anyhow.

I needed to be logged in as the mysql exclusive user.


--
James Riordon
SysAdmin
http://www.amigo-3.com