/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 votes68 views1 answer
7z linux extract to folder
Shell/Bash
0 vote124 views2 answers
Kibana should not be run as root
Shell/Bash
0 vote117 views2 answers
Ip address regex validate cmd
Shell/Bash
3 votes110 views5 answers
Ffmpeg mp4 to webm vp8
Shell/Bash
9 votes132 views5 answers
Check react version
Shell/Bash
0 vote114 views2 answers
Regex for ips
Shell/Bash
9 votes132 views2 answers
Docker remov all running containers
Shell/Bash
0 vote119 views1 answer
Manjaro notion
Shell/Bash
1 vote108 views4 answers
How to install typescript on ubuntu
Shell/Bash
0 vote113 views1 answer
How to uninstall pycharm professional in ubuntu 16.04
Shell/Bash