To fix ER_NOT_SUPPORTED_AUTH_MODE error on MySQL server, we add the user.
For instance, we run
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
to add the root user to the database so we can log in with the user in our apps.
