So you forgot your MySQL database password ? Don’t worry, I’ll go straight to the point:
- Stop your running mysqld instances (/etc/init.d/mysql-server stop or killall mysqld)
- # mysqld –skip-grant-tables
- # mysql -uroot and you’re in, easy, isn’t it ?
For god sake, don’t do this on a production server leaving mysqld running like this X”D