/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 vote337 views1 answer
How to install lazygit on ubuntu
Shell/Bash
70 votes318 views5 answers
Install docker ubuntu 20
Shell/Bash
0 vote366 views1 answer
Precompile bits/stdc++.h
Shell/Bash
47 votes341 views5 answers
Git remember credentials
Shell/Bash
0 vote318 views1 answer
-v /var/run/docker.sock jenkins/jenkins
Shell/Bash
11 votes342 views4 answers
Install curl on ubuntu
Shell/Bash
0 vote339 views1 answer
Bash: /proc/sys/vm/drop_caches: Permission denied
Shell/Bash
1 vote328 views1 answer
Homebrew PHP appears not to be linked. Please run [valet use [email protected]]
Shell/Bash
0 vote358 views1 answer
Protect chrome passwords with a password in ubuntu
Shell/Bash
1 vote406 views1 answer
How to filter 12 character words from file bash
Shell/Bash