how to set mysql password

Steps

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('current_password');

substitute user for the username in question, host for the servername (for me it was localhost), and current_password for the password you use to login to the database. You should leave all the single quotes in the statement