plantnanax.blogg.se

Excel connect to mysql hosted on vm
Excel connect to mysql hosted on vm




SSHClientCert: Set this to the name of the certificate store for the client certificate.To access MySQL data via SSH, configure the following connection properties: Using SSH, you can securely login to a remote machine. SSLServerCert: The certificate to be accepted from the server.SSLClientCertType: The certificate type of the client store.Used to locate the certificate in the store. SSLClientCertSubject: The subject of the TLS/SSL client certificate.SSLClientCertPassword: If a client certificate store is password-protected, set this value to the store's password.Used in the case of 2-way SSL, where truststore and keystore are kept on both the client and server machines. SSLClientCert: Set this to the name of the certificate store for the client certificate.Configure the following connection properties to connect to data: You can leverage SSL authentication to connect to MySQL data via a secure session. If this is not set, tables from all databases will be returned. Database: The default database to connect to when connecting to the MySQL Server.You can also optionally set the following: Port: The port of the server hosting the MySQL database.Server: The host name or IP of the server hosting the MySQL database.The following connection properties are required in order to connect to data. Here you can set the connection settings, test the connection, and save the connection profile. To setup your connection, you will have to click the Select button. From the CData ribbon, click Get Data and select From MySQL to launch the CData Query window.






Excel connect to mysql hosted on vm