How to change MySQL user password. To change the password of a non-root user, once logged in, run the following query: ... How to Query Multiple Tables in SQL. How to show MySQL users and passwords.