/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

7 votes232 views6 answers
Flutter doctor android studio not installed
Shell/Bash
1 vote239 views1 answer
Failed to open stream: Permission denied in path on mac
Shell/Bash
2 votes251 views4 answers
How to install vue router
Shell/Bash
1 vote244 views1 answer
How to install to mysql server in powershell
Shell/Bash
0 vote233 views1 answer
Video imagemagick with name filename on frame
Shell/Bash
2 votes251 views1 answer
Better discord how to install plugins
Shell/Bash
0 vote211 views1 answer
Filetype exfat not configured in kernel
Shell/Bash
0 vote235 views1 answer
Automate tmux
Shell/Bash
0 vote234 views1 answer
Axel download google drive
Shell/Bash
0 vote228 views1 answer
List of global git config
Shell/Bash