Ubuntu – Which is the easiest way to reset the thesql root password

MySQLpassword

In the past there has been sudo /etc/init.d/mysql reset-password, (1) is manually restarting and setting the password with an sql command again required? (2)

(1) http://www.ubuntugeek.com/reset-the-root-password-on-mysql.html
(2) http://www.howtoforge.com/reset-forgotten-mysql-root-password

Best Answer

There's also an administrative user equivalent to root: debian-sys-maint. You can use this account to reset root's password. You can find its password in /etc/mysql/debian.cnf

Related Question