• Replace {passwd} with the password of the user.
• Replace {user} with the name of the user.

GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}';
FLUSH PRIVILEGES;

Or you can alternatively use the following:

UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE USER='{user}';
FLUSH PRIVILEGES;