/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

16 votes253 views2 answers
Firebase cli get current project
Shell/Bash
2 votes294 views1 answer
Install wps ubuntu 20.04
Shell/Bash
1 vote279 views1 answer
Check active ssh connections on linux
Shell/Bash
0 vote232 views1 answer
Install a python package and use in nodejs
Shell/Bash
0 vote271 views1 answer
Error: Couldn't find that app. » » Error ID: not_found
Shell/Bash
5 votes284 views6 answers
How to install webpack
Shell/Bash
0 vote276 views1 answer
Generate uml from python code
Shell/Bash
25 votes295 views2 answers
Untar xz
Shell/Bash
0 vote291 views2 answers
Umount device is busy
Shell/Bash
1 vote301 views2 answers
Fix SSH Error in Terminal & Linux: client_loop: send disconnect: Broken pipe
Shell/Bash