Reset mysql root password after phpmyadmin corrupted it

Question

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,

Can you post the tail of the MySQL error log? On Ubuntu this will do it - not sure if RHEL puts it in the same place: tail /var/log/mysql.err — , Jul 06 '11 at 02:17

score 2 · Accepted Answer · answered Jul 07 '11 at 03:26

2

You have a typo

mysqld_safe –skip-grant-tables -u root &

should read

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

answered Jul 07 '11 at 03:26

RolandoMySQLDBA

16,364
3
47
80

score 0 · Answer 2 · edited Apr 13 '17 at 12:14

0

Recently addressed:

Lost MySQL password

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

edited Apr 13 '17 at 12:14

Community

1

answered Jul 07 '11 at 03:37

arkigos

236
1
3

Reset mysql root password after phpmyadmin corrupted it

2 Answers2