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

Today found that WordPress can not connect to the database, log in to the window server server to check, all services are running normally.

Log in to the mysql database using the root account, and the results indicate that the passwords do not match. I suddenly realized that the server may have been attacked by SQL injection.

As for the cause of the accident and the remedial measures taken afterwards, I will talk about it later when I have a chance. Here I will mainly talk about the steps to reset the password of the mysql user.

Reset root password

If you forget your root password, you can enter mysql's secure mode and reset your root password.

1. Stop the MySQL service

Open a command prompt window and type net stop mysql to turn off the MySQL service.

C:\ Users\ Administrator > the net stop mysql57MySQL57 service is stopping.. the MySQL57 service has been stopped successfully.

↑ service names are not always mysql. For example, mine is mysql57,57, which represents a version number of 5.7.

Of course, you can also turn off the MySQL service through the computer management panel.

two。 Change to the bin directory

In the command prompt window, use the cd command to change to the bin directory under the mysql installation directory.

C:\ Users\ Administrator > cd C:\ Program Files\ MySQL\ MySQL Server 5.7\ binC:\ Program Files\ MySQL\ MySQL Server 5.7\ bin >

The default installation directory for ↑ is C:\ Program Files\ MySQL\ MySQL Server

3. Enter safe mode

Enter mysqld-- skip-grant-tables in the bin directory to skip the permission check to start mysql.

If you have configured the my.ini file, you need to bring it in: mysqld-- defaults-file= ".. / my.ini"-- skip-grant-tables

[mysqld] basedir = "C:\ ProgramData\ MySQL\ MySQL Server 5.7" datadir = "C:\ ProgramData\ MySQL\ MySQL Server 5.7\ Data"

↑ I specified the path where the data is stored in the my.ini file, and if I don't introduce a configuration file, I will prompt for a No such file or directory error.

4. Reset account password

Open another command prompt window (do not close the safe mode window), also change to the mysql\ bin directory, and type mysql to skip permission verification to connect to the database.

C:\ Program Files\ MySQL\ MySQL Server 5.7\ bin > mysqlServer version: 5.7.16 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql >

↑ can also specify the connection parameter mysql-u-p-h-P-D

Execute update mysql.user set authentication_string= "" where user= "root"; reset the password of the root user (the password field before 5.7).

Mysql > update mysql.user set authentication_string= "" where user= "root" Query OK, 1 row affected (0.00 sec) mysql > select user Authentication_string from mysql.user\ row * 1. Row * * user: rootauthentication_string:** 2. Row * * user: mysql.sysauthentication_string: * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE2 rows in set (0.00 sec)

The authentication_string field for ↑ root users has been cleared

5. Refresh permissions table

Execute the flush privileges; command to refresh the permission table, the password has been reset, type quit to exit.

Mysql > flush privileges;Query OK, 0 rows affected (0.02 sec) mysql > quitBye

Close all command prompt windows and end the mysqld.exe process through the task manager. Restart the MySQL service, and then you can log in to the root account directly.

Modify root password

For security reasons, the root password should not be empty, so you need to reset the password after the password is reset.

Method 1: SET PASSWORD

SET PASSWORD FOR "username" = PASSWORD ("new password")

Log in to mysql as root and use the set password command to change the password:

Mysql > set password for root@localhost = password ("pswd"); Query OK, 0 rows affected, 1 warning (0.00 sec)

Method 2: mysqladmin

Mysqladmin-u "username"-p password "new password"

After performing the naming, you will be prompted to enter the original password, which can be modified after you enter it correctly.

C:\ Program Files\ MySQL\ MySQL Server 5.7\ bin > mysqladmin-u root-p password pswdEnter password: * mysqladmin: [Warning] Using a password on the command line interface can be insecure.Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

Method 3: UPDATE TABLE

UPDATE mysql.user SET authentication_string=PASSWORD ("new password") WHERE user= "username"

When you reset the root password, you can also set the default password. However, the password cannot be in clear text and must be encrypted using the password () function.

Mysql > update mysql.user set authentication_string=password ("pswd") where user= "root"; Query OK, 1 row affected, 1 warning (0.00 sec) mysql > flush privileges;Query OK, 0 rows affected (0.01 sec)

Summary

The above is the whole content of this article on the method of resetting the root password of mysql under windows. I hope it will be helpful to you. Interested friends can continue to refer to this site:

Detailed explanation of MySQL Database Design using Python Operation Schema method

Introduction of Fuzzy query method using instr in mysql

Example of or statement usage in MySQL

If there are any deficiencies, please leave a message to point out. Thank you for your support to this site!

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.