Update user's password

Enter your root user name and password to complete the login.

use mysql;

Next we’ll update the password for all MySQL users with the name user_name. Be sure to replace your_new_password with the actual new password:

update user set password=PASSWORD('your_new_password') where User='user_name';

Finally, reload the privileges, and quit mysql:

flush privileges;
quit