- Friday, January 1, 2010, 12:22
- Databases FAQ, Tech Tips
- 175 views
What happens if you forget your MySQL root password ?. Actually its very simple to reset, below are the steps to achieve that,
First you have to kill all the mysqld instances that are currently running,
#killall mysqld
Now start the mysql daemon as below,
#/usr/libexec/mysqld -Sg --user=root &
You may also try the below command,
mysqld --skip-grant-tables --user=root
Full story