Solved

Remove SSL requirement

Posted on 2013-01-15
2
3,759 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 500 total points
ID: 38782945
GRANT USAGE ON *.* TO ‘encrypted_user’@’%’ REQUIRE NONE

Alternatively, delete and recreate the user.
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

626 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