/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 vote206 views1 answer
Mikrotik address list log into file
Shell/Bash
0 vote192 views1 answer
Webgl server
Shell/Bash
10 votes193 views6 answers
No module named psycopg2
Shell/Bash
20 votes200 views6 answers
Image in github readme
Shell/Bash
6 votes221 views4 answers
Create express app
Shell/Bash
-1 vote200 views1 answer
Empty-commoit
Shell/Bash
0 vote187 views1 answer
Debian show auto install package
Shell/Bash
1 vote186 views1 answer
Install fabric sample
Shell/Bash
0 vote211 views1 answer
Alpine add user
Shell/Bash
2 votes191 views1 answer
How to start a web server linux
Shell/Bash