phpmyadmin authorization errors?

Question

PHP

There is such a thing, I enter the root password is empty, mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] and also mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

Answer 1

In the eighth muscle, the authorization method has changed
https://bugs.php.net/bug.php?id=76243
Here are solutions to choose from:
https://stackoverflow.com/questions/49948350/phpmy...

Answer 2

root user? Did you just install it? Try root root as login and password.

Answer 3

it is possible by analogy with where root is DBName is the name of the database mysqli_connect('127.0.0.1','root','','DBName');

Answer 4

C:\Windows\system32>c:\Server\bin\mysql-8.0\bin\mysql.exe -u root
Welcome to the MySQL monitor. Commands end with ; or\g.
Your MySQL connection id is 17
Server version: 8.0.19 MySQL Community Server - GPL
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> ALTER USER 'root'@'localhost'
-> IDENTIFIED WITH mysql_native_password
-> BY 'pass';
Query OK, 0 rows affected (0.