Shulou(Shulou.com)06/02 Report--

This article mainly explains the "mysql password forgot how to reset", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "mysql password forgot how to reset" it!

The method of modifying New password by MySQL

Remember to change the new password in the case of the original password:

After logging in to the database, enter the set password for user name @ localhost = 'new password'; to set the new password, don't forget the semicolon.

As shown in the figure: change the new password to admin for root users in the native localhost MySQL database system

Change the password of the root@localhost user to admin: set password for root@localhost = 'admin'

MySQL forgot password, reset password method

If you forget the login password, reset the user login password for the MySQL database system by step-by-step.

1. Open cmd as an administrator, make sure the mysql service is turned off, and cmd enter the command: net stop mysql

Ps: the version of mysql installed by the author is

two。 Change the directory from the default C disk location to the mysqld.exe installation directory (such as my directory: d:\ Program Files\ MySQL\ MySQL Server 5.7\ bin)

Enter the following command in the cmd black window to change to the installation directory of mysqld.exe

(usually under the xxx\ MySQL\ MySQL Server 5.7\ bin directory)

Execution here will only have the cursor in a flash can not continue to write commands or enter any commands, so re-open a cmd window

4. Do the following in the new cmd window (you can open a new cmd window as an administrator or not)

Change to the installation directory of mysqld.exe, log in to MySQL with no account password, and then reset the password of the database system root user to admin

If you forget your password, reset the password is complete!

Thank you for reading, the above is the "mysql password forgot how to reset" the content, after the study of this article, I believe you forget how to reset the mysql password has a deeper understanding of this problem, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.