/Shell/Bash/Php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

Php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

I solve this by SQL command:

ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';

which is referenced by https://dev.mysql.com/doc/refman/8.0/en/alter-user.html

if you are creating new user

 CREATE USER 'jeffrey'@'localhost' IDENTIFIED WITH mysql_native_password BY 'passwor

Source: stackoverflow.com

Similar codes

4 votes261 views3 answers
Top programming languages to learn
Shell/Bash
0 vote175 views1 answer
Composer installed versions
Shell/Bash
0 vote235 views2 answers
Awk output field separator
Shell/Bash
0 vote165 views1 answer
Git add only c files
Shell/Bash
0 vote163 views1 answer
Conda install cffi
Shell/Bash
0 vote179 views1 answer
Install nixos mac m1
Shell/Bash
0 vote174 views1 answer
PowerShell command list software windows server 2016
Shell/Bash
0 vote168 views1 answer
How to check hugo version
Shell/Bash
-4 votes191 views2 answers
Bash not found docker
Shell/Bash
0 vote166 views1 answer
Hue run command line arguments
Shell/Bash