(How i fixed) SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

gistfile1.txt

1. First edit the mysql config e.g. /etc/mysql/my.cnf & added the following:

[mysqld]
default_authentication_plugin= mysql_native_password

2. Then run the following command:

mysql_upgrade -u root -p --default-auth=mysql_native_password

3. If above command succeeds, then login into mysql server:

mysql -u root -p

4. Lastly the update password for the user you want to change:

ALTER USER 'myuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';