Mysql recover root password

Boot en “single mode”

1
2
# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &

Reset pass

1
mysql> use mysql; update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; flush privileges;