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

This article will explain in detail the method of changing the login password of mysql8 for everyone. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

mysql8 How to change the login password: 1. Log in to mysql;2. Use the command "ALTER USER 'test'@'localhost ' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY ' new password';" to modify the password.

Example: Modify the login password of test user in user table in mysql database.

MySQL version number: 8.0.15

Steps:

1. Log in to mysql

mysql -u root -p Enter your login password

2. Use MySQL database

USE mysql

3. Change password

ALTER USER 'test'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'new password';

4. Verify whether the modification is successful

mysql -u test -p Enter a new password About mysql8 change login password method shared here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.