xxxxxxxxxx
code: 'ER_NOT_SUPPORTED_AUTH_MODE'
errno: 1251
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MariaDB client'
If you're using mysql server version 8, you need to install mysql server 5.7
and it works as expected.
Then,
1. ctrl + alt + delete.
2. go to services then stopped the process MySQL8 to install MySQL5 in 3306 port.
xxxxxxxxxx
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'