[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



"Jaime F. Castillo" <jaime@xxxxxxxxxxxxxxxxx> wrote:
> 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 /]# /usr/sbin/mysqld --skip-grant-tables
> Fatal error: Please read "Security" section of the manual to find out how
to
> run mysqld as root!
> 011203 17:29:11  Aborting

Check to see what user MySQL runs as.  An easy way to do that is to check
who owns /usr/sbin/mysqld.  If you're MySQL is configured to run as user
"mysql" you should "su - mysql" first.  If not, replace "mysql" with the
appropriate user, then follow the instructions you have.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/