This question already has an answer here:
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 &  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?