Detailed steps to change the default password when installing MySQL in Ubuntu

Step 1: Enter the directory: cd /etc/mysql, view the debian.cnf file

Step 2: Log in to MySQL using the account and password in the figure above.

Step 3: View the libraries in the database.

Step 4: Use the mysql library.

Step 5: Use the following statement update user set authentication_string=PASSWORD("自定義新密碼") where user='root';

I personally keep it simple. The account is: root. Password: 123456.

Step 6: Execute the following statement: update user set plugin="mysql_native_password";

Step 7: Refresh: flush privileges;

Step 8: Exit: quit;

Step 9: Password change is complete. In the command box, enter ：/etc/init.d/mysql restart; restart MySQL

Last step: log in again. Congratulations, you have successfully changed the default password.

Summarize

The above are the steps for changing the default password of MySQL installed in Ubuntu. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!