/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

21 votes348 views1 answer
How to get homebrew
Shell/Bash
3 votes328 views1 answer
Yusuke persona 5
Shell/Bash
3 votes331 views2 answers
Rsync with ssh key
Shell/Bash
11 votes337 views2 answers
Git add file to last commit
Shell/Bash
4 votes325 views5 answers
Kubectl get pods
Shell/Bash
0 vote330 views1 answer
Git apply exclude file
Shell/Bash
1 vote347 views1 answer
How to convert .qrc file in python
Shell/Bash
0 vote323 views1 answer
Intall docker ubuntu command
Shell/Bash
0 vote404 views1 answer
Apache Webserver does not show directory listings but 403 - Yosemite
Shell/Bash
17 votes356 views6 answers
How to add images in readme github
Shell/Bash