/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

0 vote324 views1 answer
Debian install dig
Shell/Bash
0 vote361 views1 answer
Remove last field using awk
Shell/Bash
0 vote341 views1 answer
Npm TypeError [ERR_INVALID_ARG_TYPE]:
Shell/Bash
0 vote324 views1 answer
How to get a zombie villager in minecraft
Shell/Bash
0 vote317 views1 answer
Where can I find ubuntu shortcut wsl
Shell/Bash
12 votes334 views2 answers
Image in github markdown
Shell/Bash
10 votes348 views4 answers
Ssh-copy-id example
Shell/Bash
0 vote311 views1 answer
To add repo from github in linux
Shell/Bash
0 vote308 views1 answer
Hay una opción git-merge seco-run
Shell/Bash
0 vote325 views1 answer
Open image from terminal in ubuntu 18
Shell/Bash