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
Solved

Remove SSL requirement

Posted on 2013-01-15
2
3,489 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 50

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL Init Waits 25 121
MYSQL database problem within Coldfusion 2016 environment 12 49
Complex MySQL Query 2 33
Inserting data into database 10 36
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 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