MySQL password reset

Forgot the root user password for MySQL and prompted when trying to connect:

Mysqladmin:connect to server at ' localhost ' failed

Error:access denied for user ' root ' @ ' localhost ' (using password:no).

Stop MySQL Services # service mysqld stop

Start Mysqld_safe and skip the start authorization table. The Skip-grant-tables parameter at startup is designed to not start the Grant-tables, authorization table when MySQL is started. This will allow you to change the root password.

# Mysqld_safe--skip-grant-tables &

MySQL password reset