Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4199
  • Last Modified:

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?
0
shankshank
Asked:
shankshank
1 Solution
 
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
 
Steve BinkCommented:
GRANT USAGE ON *.* TO ‘encrypted_user’@’%’ REQUIRE NONE

Alternatively, delete and recreate the user.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now