Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

First you must register the MySQL servers that SQL DM for MySQL shall connect to. For every server you specify here, an embedded database will be created. SQL DM for MySQL will connect to those servers, retrieve and store information from that server.

 Image Modified


For a Direct connection, just enter the connection information as you would do from any client.

...

If you want to use SSH tunneling to your MySQL server, you have to provide details for creating a SSH connection. Please refer to Using SSH connections, below.

To connect using SSH tunneling

...

  • TCP port forwarding must be allowed in the SSH server. For openSSH servers it should be done in the "sshd_config" configuration file. In Linux usually it is in, /etc/ssh/sshd_config.

Set the "AllowTcpForwarding" option to "yes". So it should look like,

Code Block
themeConfluence
AllowTcpForwarding yes


  • MySQL host should be specified 'relative' to the SSH server. Say, your SSH server is running in M1. Then you should ask yourself the following question: How should I connect to the target MySQL server from M1?

...

  • Client Key: Private key of the client that is needed for encryption.
  • Client Certificate: The client certificate.

Image Modified