PHP mysqli_connect authentication caching_sha2_password

Tweet
Share
Share
Pin

I recently had a database with the latest MySQL which does not use the traditional mysql_native_password so I had to alter my user via the terminal to change the type.

Below I will list the changes you can do to fix the database and be able to connect

error: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in...

SQL Command to Alter User

ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';

SQL Command to Create a New User

 CREATE USER 'jeffrey'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';