You may forget root password of your mysql database, follow instruction below to reset it.

  • Add a entry in my.cnf:
mysqld_safe --skip-grant-table&
  • 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 1 after this command:


Published

05 August 2013

Category

operation

Tags