Given a MySQL system with multiple remote users (users of the form
GRANT USAGE ON *.* TO 'joecool'@'192.168.1.2' REQUIRE SSL;
The (formerly) accepted answer by Honza seems incorrect, see its comments. It seems not possible to use a
GRANT query to alter multiple users at once since MySQL does not support wildcards for user names.
As you suggested yourself you can alter records in the
mysql.user table directly using an
UPDATE query and as Marc Delisle suggested, afterwards flush priviliges with: