Précédent	Table des matière	Suivant

4.12.5 Se connecter à un serveur lointain MySQL avec Win32 et SSH

Here is a note about how to connect to get a secure connection to remote MySQL server with SSH (by David Carlson).

• Install SSH client on your windows machine - I used a free SSH client from http://www.doc.ic.ac.uk/~ci2/ssh/. Other useful links: http://www.npaci.edu/Security/npaci_security_software.html and http://www.npaci.edu/Security/samples/ssh32_windows/index.html.
• Start SSH. Set Host Name = yourmysqlserver name or IP address. Set userid=your userid to log in to your server
• Click on "local forwards". Set local port: 3306, host: localhost, remote port: 3306
• Save everything, otherwise you'll have to redo it the next time.
• Log in to your server with SSH.
• Start some ODBC application (for example Access)
• Create a new file and link to mySQL using the ODBC driver the same way you normally do except for server, user "localhost".

That's it. It works very well with a direct Internet connection. I'm having problems with SSH conflicting with my Win95 network and Wingate - but that'll be the topic of a posting on another software company's usegroup!

	Table des matières
Précédent		Suivant