How do one update or change the MySQL user password? Assume that the username is AbundantCode whose password needs to be changed from test to test1. You can run the following command in the MySQL shell.