/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

1 vote133 views1 answer
Adb get imei number
Shell/Bash
0 vote150 views1 answer
Install laravel mix
Shell/Bash
0 vote132 views1 answer
Install OMV core packages on Debian
Shell/Bash
0 vote137 views1 answer
How to use nohup
Shell/Bash
0 vote159 views1 answer
Bash toggle script
Shell/Bash
5 votes154 views3 answers
Set git editor
Shell/Bash
2 votes151 views1 answer
Echo aws profile
Shell/Bash
0 vote142 views1 answer
Create a git repository from local machine and push it online
Shell/Bash
13 votes154 views1 answer
Another git process seems to be running in this repository
Shell/Bash
2 votes136 views4 answers
Add gif to readme.so
Shell/Bash