Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

looking for a security to secure MySQL server. i am trying SSL using OpenSSL but I have no idea on how to do it for Windows without the shell command line. are they any more direct or easier security for MySQL server? anyone have any idea? thanks.

share|improve this question
Please clarify what you mean by "secure MySQL". Do you mean the entire server or just remote connections? – John Gardeniers Sep 7 '10 at 2:55
just remote connections – JCX Sep 7 '10 at 5:37


There is a good section of the MySQL Manual which covers using SSL (either yaSSL or OpenSSL). It can be found here:


share|improve this answer

Chris Calendar's blog has a good post that walks through the complete steps for setting up SSL for MySQL on Windows. You will have to use the Command Prompt, though.

share|improve this answer

These days my tool of choice for this is HeidiSQL, which will allow you to use an SSL connection without the need for other software. I use it regularly for managing a MySQL instance on a remote Linux machine from my Windows workstation.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.