MySQL 8.0 - Client does not support authentication protocolb(mysql_native_password) requested by server; consider upgrading MySQL client

• PHP 5 เชื่อมต่อกับ MySQL 8 แล้วมีปัญหา เรื่องไม่ support mysql_native_password

Solved

mysql > ALTER USER 'myuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypassword';

mysql> flush privileges;

Ref

https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server