To change back and NOT use mysql_native_password and use caching_sha2_password do the following:
-
- login to mysql by running following command
sudo mysql -p
-
- At password prompt, enter your mysql password
- Run following command to change back to use caching_sha2_password
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password;