How-to Change back and NOT use mysql_native_password

PhpMySQL Help!  > Uncategorized >  How-to Change back and NOT use mysql_native_password
0 Comments

To change back and NOT use mysql_native_password and use caching_sha2_password do the following:

    1. login to mysql by running following command

sudo mysql -p

    1. At password prompt, enter your mysql password
    2. Run following command to change back to use caching_sha2_password

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password;

Leave a Reply

Your email address will not be published. Required fields are marked *