Node js
MySQL 8.0
to change the authentication method for the specific user to use mysql_native_password
avoids upgrading the client
resolves compatibility issues
1. ALTER USER 'your_username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
2. FLUSH PRIVILEGES;
Client does not support authentication protocol requested by server consider upgrading MySQL client