Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
n.m.
Programming language:
SQL
2021-03-20 16:55:20
0
Q:
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
Richard Muthwill
Code:
SQL
2021-08-02 12:47:29
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
0
Tags
server
unknown
request
method
Related
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.
Couldn't connect :( Error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client 2020
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
php catch mysqli_connect(): (HY000/1045): Access denied
mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers
php mysqli connect err0r
New to Communities?
Join the community