/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

4 votes189 views4 answers
Array length bash
Shell/Bash
0 vote186 views1 answer
Install kali software manager gnome support
Shell/Bash
38 votes163 views3 answers
Install homebrew mac m1
Shell/Bash
1 vote145 views1 answer
Utorrent on ubuntu
Shell/Bash
1 vote147 views1 answer
How to close jobs in linux
Shell/Bash
1 vote154 views1 answer
Start ubuntu hotspot from terminal
Shell/Bash
0 vote141 views1 answer
Babel source maps
Shell/Bash
1 vote154 views1 answer
K8s get current context
Shell/Bash
0 vote182 views1 answer
Ubuntu install iptables-persistent
Shell/Bash
0 vote138 views1 answer
How to find empty folders linux
Shell/Bash