Mega Code Archive

 

Categories / MySQL / User Permission

 

Now take a look at an example of a GRANT statement that uses a REQUIRE clause

GRANT SELECT, UPDATE (BookTitle, Copyright) ON test.Books TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1' REQUIRE SSL;