Remove SSL requirement

I forced a user to require SSL on mysql by doing this command
GRANT USAGE ON *.* TO ‘encrypted_user’@’%’ REQUIRE SSL

How do i remove that need?
LVL 5
shankshankAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Steve BinkConnect With a Mentor Commented:
GRANT USAGE ON *.* TO ‘encrypted_user’@’%’ REQUIRE NONE

Alternatively, delete and recreate the user.
0
 
Mark GilbertSenior Performance EngineerCommented:
Either delete that specific entry in the 'mysql' table, or if you are uncertain of how to get into the mentioned database you could delete the user, then re-set them up without defining require ssl.
0
All Courses

From novice to tech pro — start learning today.