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

["Andras Kende" <andras@xxxxxxxxx>]

----- Original Message ----- 
From: "Correllia Fuengabe" <corras4@xxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Wednesday, May 01, 2002 7:25 PM
Subject: [cobalt-users] MySQL not allowing "--skip-grant-tables" as root!


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

Hello,

Had a same problem..... Try this :)

/usr/bin/safe_mysqld  --skip-grant-tables

Also for me UPDATE didnt work ... So I used GRANT like below...

http://mysql.com/doc/R/e/Resetting_permissions.html
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Andras