Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Remove SSL requirement

Posted on 2013-01-15
2
Medium Priority
?
3,984 Views
Last Modified: 2013-01-29
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
Comment
Question by:shankshank
2 Comments
 
LVL 18

Expert Comment

by:Mark Gilbert
ID: 38781656
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
 
LVL 51

Accepted Solution

by:
Steve Bink earned 2000 total points
ID: 38782945
GRANT USAGE ON *.* TO ‘encrypted_user’@’%’ REQUIRE NONE

Alternatively, delete and recreate the user.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question