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

[Correllia Fuengabe <corras4@xxxxxxxxx>]

--- Andras Kende <andras@xxxxxxxxx> wrote:
> 
> ----- 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
> 
> 


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