Support for REQUIRE <SSL, etc> in mysql_grants state

Addresses issue #5778 - tested locally and works for me.