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

[Correllia Fuengabe <corras4@xxxxxxxxx>]

Dear Andras,

Many thanks!  Your recommendation of:
"/usr/bin/safe_mysqld  --skip-grant-tables"
did the job!

I did manage to use the normal:
----------
UPDATE user SET Password=PASSWORD("<<NewRootPass>>")
WHERE User="root";
----------
syntax though.

Prefer this as I know I am just changing password and
nothing else!

THANKS AGAIN FOR SUCH A QUICK REPLY!

(If only Cobalt patches where issued as quickly and
effectivey :-)

Corrie



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