Author Topic: MySQL 8.0+ the server requested authentication method unknown to the client  (Read 2899 times)

golfreeze

  • Administrator
  • Hero Member
  • *****
  • Posts: 2140
    • View Profile
    • นั่งสมาธิ สติปัฏฐานสี่ พาเที่ยววัด แนะนำวัด แจกcd ธรรมะฟรี
    • Email
MySQL 8.0+ the server requested authentication method unknown to the client
« on: สิงหาคม 10, 2019, 01:39:55 PM »
PHP7.x with MySQL 8.0+ error: The server requested authentication method unknown to the client

=> error : the server requested authentication method unknown to the client

== fixed by use mysql_native_password
ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';