MySQL password change method

Methods for changing passwords in MySQL include using the UPDATE statement to change the password, using the SET PASSWORD statement to change the password, using the mysqladmin command to change the password, using the GRANT statement to create a new user and set a password, etc. : 1. Use the UPDATE statement to modify. If you have sufficient permissions, you can use the UPDATE statement to directly modify the MySQL user's password; 2. Use the SET PASSWORD statement to modify the password, etc.