reset mysql root password
You may forget root password of your mysql database, follow instruction below to reset it.
- Add a entry in
- then restart mysql server, now you can login as root without prompting password.
- execute as below:
use mysql; update user set password=password("123456") where user='root'; flush privileges;
- Do not forget to delete the entry you have added in step
1after this command:
05 August 2013