What if installing the latest version of MySQL causes login phpMyAdmin to report an error?

This article will explain in detail how to install the latest version of MySQL to log in to phpMyAdmin to report an error. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Installing the latest version of MySQL caused an error in login phpMyAdmin

Login with phpMyadmin after installing the latest version of mysql, encountered an error

The first kind of error report:

Mysqli::real_connect (): (HY000/2002): No such file or directory

Solution:

In the / libraries/config.default.php and / config.sample.inc.php files

$cfg ['Servers'] [$I] [' host'] = 'localhost'

Change to

$cfg ['Servers'] [$I] [' host'] = '127.0.0.1'

The second kind of error report:

Mysqli_real_connect (): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect (): (HY000/2054): The server requested authentication method unknown to the client

Solution:

Terminal login mysql

Mysql-u root-p

Modify authorized user

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'

Password is the mysql login password

About "install the latest version of MySQL caused login phpMyAdmin error how to do" this article is shared here, 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, please share it out for more people to see.