Forum Thread: Can't Reset My MYSQL Password

Hi,everyone! I use mysql at the first time,and when i try to login,it needs password which is not "toor".So i search it online and find the answer:i need to reset my password...then i followed this articlehttp://www.cyberciti.biz/tips/recover-mysql-root-password.html

But when i tried step2,i was blocked by the output as shows below...anyone can help? Thanks in advanced.

Can't Reset My MYSQL Password

7 Responses

you can use mysql -u root -p ,then press enter, it has no password. If you understand sql, you can change password. host in user table.

I have tried this command u said before i posted the question,but it didn't work.

try to remove log
rm /var/log/mysql/error.log
and then
/etc/init.d/mysql stop
mysqldsafe --skip-grant-tables &

Thanks,but it still doesn't work...

Anyway,i have solved it ...

pls, tell me.
how to solve it's

Just do what that articlehttp://www.cyberciti.biz/tips/recover-mysql-root-password.html tells u to do and ignore the output:)

Share Your Thoughts

Hot
Active