How to change MySQL user password. To change the password of a non-root user, once logged in, run the following query: ALTER USER ‘username’@‘host’ IDENTIFIED BY ‘PASSWORD’; ...

To change to mysql_native_password plugin, login to MySQL as root user: $ mysql -u root -p. If you are using auth_socket plugin, you should enter the following command to login into MySQL server as ...