Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
2  
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

3 Answers 3

JCX,

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

http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html

Chris

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.

http://www.chriscalender.com/?p=448

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

 
discard

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.