Shulou(Shulou.com)05/31 Report--

This article is to share with you about the solution to the failure of phpmyadmin password login in mysql8. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Mysql8 phpmyadmin password login failed

On the CVM, after configuring mysql, the deployment of phpmyadmin is completed, but the account password entered on the web page is always unable to log in, which is later found to be caused by inconsistent mysql8 password policies.

Old version, password authentication using mysql_native_password

The new version uses caching_sha2_password

Phpmyadmin logs in with old authentication, so you can't log in

The solution here changes the password authentication method to the old version

1 root select user,host,plugin from mysql.user; to check the current password account verification method (here root has been changed to the old version)

+-+ | user | host | plugin | +- -+ | admin |% | caching_sha2_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | mysql_native_password | +- -+

2. The new version of the variable is somewhat different from the old version. You can view the variable through show variables like 'validate_password%';.

+-- +-+ | Variable_name | Value | +-- +-+ | validate_password.check_user_ Name | ON | | validate_password.dictionary_file | | validate_password.length | 6 | | validate_password.mixed_case_count | 1 | validate_password.number_count | 1 | validate_password.policy | LOW | | validate_password.special_char_count | 1 | +- -+

3. Perform the new version of encryption.

ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '111111 investors Lush PRIVILEGES

Note that the password strength of the new version is relatively high. If the value of validate_ password.policyis not low, you cannot set a simple password.

The password is too simple, resulting in failure to change the secret, the solution

Check password-related settings through the above 2, mainly validate_password.length and validate_password.policy

Set global validate_password.policy=LOWset global validate_password.length=6

And then you can change the password.

Thank you for reading! This is the end of this article on "the solution to the failure of phpmyadmin password login in mysql8". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.