MySQL forgot root password workaround

# First make sure the MYSQLD service is stopped and then start the MySQL service with the mysqld_safe command: Mysqld_safe--skip-grant-tables log in as root user mysql-uroot# Use the Updata statement to modify the password update mysql.user SET Password = Password (' Test ') WHERE user = ' root ' and Host = ' localhost '; FLUSH privileges;# Restart database service mysqld restart

Note: The change password can only be modified by the Updata statement, not by the SET statement, otherwise it will be an error.

This article is from the "Last Night Stars" blog, please make sure to keep this source http://yestreenstars.blog.51cto.com/1836303/1682513

MySQL forgot root password workaround