Home / server / Questions / 287738
Accepted
RichardW11
Asked: 2011-07-06 17:54:43 +0800 CST

Reset mysql root password after phpmyadmin corrupted it [duplicate]

  • 772

So I tried to change my mysql root password for the first time using a advanced pattern and it looks like phpmyadmin stripped the password on save. Now I can't login under root.

I am using RHEL 5 and it seems that all the instructions I keep finding don't work.

When I run the following command. I get 

[root@vault ~]# mysqld_safe –skip-grant-tables -u root &
[1] 30274
[root@vault ~]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
110705 20:38:37  mysqld ended

Does anyone know of a workaround that works?

Thanks,

mysql password root reset

2 Answers

  1. Best Answer

    You have a typo

    mysqld_safe –skip-grant-tables -u root &

    should read

    mysqld_safe -–skip-grant-tables -u root &
    • 2

  2. Recently addressed:

    Lost MySQL password

    If the --skip-grant-tables doesn't work as a flag, see above link.

    • 0