Google Answers Logo
View Question
 
Q: How to create Secure Connections to mySQL from ODBC clients ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: How to create Secure Connections to mySQL from ODBC clients
Category: Computers > Internet
Asked by: qcc-ga
List Price: $20.00
Posted: 14 May 2003 06:01 PDT
Expires: 13 Jun 2003 06:01 PDT
Question ID: 203554
How do I setup secure SSL ODBC connections from several clients on DSL
connections to a mySQL database server running on Windows 2000?

The server is running Windows 2000 Server and mySQL 3.23.55-nt.  I can
upgrade to mySQL 4 if I need to.

The clients are Windows 2000 and Windows XP connected with ODBC.

I need specific instructions on how to make the connections secure.
Answer  
Subject: Re: How to create Secure Connections to mySQL from ODBC clients
Answered By: webadept-ga on 14 May 2003 22:14 PDT
Rated:5 out of 5 stars
 
Hi, 

The best way, and only way I've ever gotten it to work, is using port
forwarding with SSH. On the MySQL website manual,  there is a page
that describes how to do this setup, step by step.

MySQL Manual | 2.6.2.4 Connecting to a Remove MySQL from Windows with
SSH
http://www.mysql.com/doc/en/Windows_and_SSH.html



Referance and Interest Links

MySQL and ODBC
http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html

Another set of instructions Instructions for SSL setup 
http://archives.postgresql.org/pgsql-odbc/2001-09/msg00040.php

S/ODBC (?) Watch out for these, they use the same as above
http://www.commandprompt.com/entry.lxp?lxpe=142


Thanks, 

webadept-ga
qcc-ga rated this answer:5 out of 5 stars

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy