php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

by

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 'password';

which is referenced by https://dev.mysql.com/doc/refman/8.0/en/create-user.html

this works for me

More Related Contents:

  1. Improve password hashing with a random salt
  2. Using PHP 5.5’s password_hash and password_verify function
  3. Hiding true database object ID in url’s
  4. Laravel – only a zero is saved to the database
  5. storing user_id in session variable
  6. I am seeing this error on submitting form Error: query was empty [closed]
  7. Convert from MySQL datetime to another format with PHP
  8. How to store repeating dates keeping in mind Daylight Savings Time
  9. Why is mysqli giving a “Commands out of sync” error?
  10. Using a .php file to generate a MySQL dump
  11. JSON encode MySQL results
  12. PHP mysql insert date format
  13. How do I execute PHP that is stored in a MySQL database?
  14. How to best store user information and user login and password
  15. Error while sending QUERY packet
  16. How to sort rows of HTML table that are called from MySQL
  17. PDO fetch one column from table into 1-dimensional array
  18. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  19. Get all mysql selected rows into an array
  20. Select from mysql table WHERE field=’$array’?
  21. MySQL ORDER BY IN()
  22. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  23. php password_verify() hash and pass won’t match
  24. MySQL query using an array [duplicate]
  25. PHP mySQL – Insert new record into table with auto-increment on primary key
  26. Create PHP array from MySQL column
  27. UNION syntax in Cakephp
  28. How do i search from serialize field in mysql database?
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment