Mysql connect
The following table describes what is needed for each field:Įnter the host name for the SQL database. This pane contains fields for entering credentials to connect to your database. By accidentally pasting whitespace, it will cause the connector to error when trying to connect. Note: When using the copy/paste function for your credentials, ensure there is no whitespace at the beginning or end of the string. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
This section enumerates the options in the Credentials and Details panes in the MySQL Connector page.
#Mysql connect full#
For the full list of IP addresses, see Whitelisting IP Addresses for Connectors. Whitelistingīefore you can connect to a MySQL database, you must also whitelist a number of IP addresses on your database server on the port you want to connect to. Also, several third-party programs offer capabilities for MySQL account administration, such as phpMyAdmin. The preferred method is to use account management statements because they are more concise and less error-prone than manipulating the grant tables directly.Īnother option for creating accounts is to use the GUI tool MySQL Workbench. These statements cause the server to make appropriate modifications to the underlying grant tables.īy manipulating the MySQL grant tables directly with statements such as INSERT, UPDATE, or DELETE. Creating MySQL Accountsīy using account management statements intended for creating accounts and establishing their privileges, such as CREATE USER and GRANT.
PEM certificate files, you can utilize the MySQL Advanced Security Connector which has a field for each file. If your SSL configuration requires use of all 3. You can also include the URL where your SSL CA Certificate is located, though this is optional.
#Mysql connect password#
The username and password you use to log into your MySQL database To connect to a MySQL database and create a DataSet, you must have the following: Limit the results set size is much as possible. Pulling data mart and data warehouse SQL queriesĮase of Use (on a 1-to-10 scale with 1 being easiest) Refer to the following link for details : The connection will trust all server certificates.
If no certificate is provided, the connection is still SSL but without any certificate authentication. This connector supports TLS IF your MySQL server supports TLS.