php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
As of PHP 7.4, this is no longer an issue. Support for caching_sha2
authentication method has been added to mysqlnd.
Currently, PHP mysqli extension do not support new caching_sha2 authentication feature.
You have to wait until they release an update.
Check related post from MySQL developers: https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/
They didn't mention PDO, maybe you should try to connect with PDO.
PHP 7.2.2 + mysql 8.0 PDO gives: authentication method unknown to the client [caching_sha2_password]
If you want to use MySQL >= 8 and you don't care about caching_sha2_password
, just select the second option when you install.
Related Topics
Why Is MySQLi Giving a "Commands Out of Sync" Error
Get All Permutations of a PHP Array
Processing Large Json Files in PHP
PHP Error: Fatal Error: Constant Expression Contains Invalid Operations
Warning: MySQLi_Select_Db() Expects Exactly 2 Parameters, 1 Given
How to Get an Unknown Username Given an Id
How to Stop People Hacking the PHP-Based Highscore Table of a Flash Game
How to Fix Error: Laravel.Log Could Not Be Opened
How to Become an Opencart Guru
List of All Locales and Their Short Codes
Is There Way to Use Two PHP Versions in Xampp
How to Detect Search Engine Bots With PHP
Remove New Lines from String and Replace With One Empty Space
Convert Flat Array to a Delimited String to Be Saved in the Database