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

This article mainly introduces how the mysql black window should change the password, the things involved, learned from the theoretical knowledge, there are many books and documents for your reference, from the perspective of practical significance, accumulated years of practical experience can be shared with you.

We all know that mysql is very powerful, but do you know how to change the password of mysql in a black window? Let's take a look at it with the editor.

Specific steps to change the password:

1. We first open the black window of mysql, start key + R to open and run, enter cmd to enter the black window, enter the bin path where the computer installs mysql, and we log in to mysql.

two。 Immediately after mysql >, enter use mysql to navigate to the mysql table, followed by a modification statement

Update user set password=password ("1") where user= "root"

In the above statement, we change the password to 1, and then we will display Query OK, which proves that the password change is successful.

3. Then enter flush privileges, and here we change the password of the mysql database.

Matters needing attention

Please restart the database if it is not successful.

These are the details of how to change the password in the mysql black window. Please pay attention to other related articles for more information.

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.