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

How does mysql change the password? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Method 1: set the password directly through the mysql console

1. Open the mysql console, enter the original mysql password, and press enter. The original password is empty, as shown in the following figure:

2. Enter the command and press enter

Set password = password ('123456')

Successfully change the password to 123456. If you want to change the password to something else, just change 123456 to the password you want to set, as shown below:

Method 2: change the password by modifying the user table in mysql

1. Open the mysql console, enter the original password, enter "use mysql;", and press enter to enter the mysql database, as shown below:

2. Enter the following command and press enter

Update user set password=password ('123456') where user='root'

This changes the original password to 123456, as shown in the following figure:

Thank you for reading! After reading the above, do you have a general understanding of how mysql changes passwords? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.