web analytics

mySQL: How to reset root password

If the password for the mysql “root” user is lost, it’s still possible reset it to some other value. The restart of the mySQL server will be necessary, of course.

The following should be done:

Stop the server It could be done normally:

/etc/init.d/mysql stop

or effectively:

ps -ef | grep mysql … mysql 25079 […]