You can create connections to one or more MySQL databases from
|D s product|
Modify the following properties as needed:
Enter your fully qualified hostname. Example:
|Port||Set this value to |
|Connect String Options|
Insert any additional connection parameters, if needed. See below.
|User Name||Username to use to connect to the database.|
|Password||Password associated with the above username.|
|Test Connection||After you have defined the connection credentials type, credentials, and connection string, you can validate those credentials.|
|Default Column Data Type Inference|
|Connection Name||Display name of the connection|
|Connection Description||Description of the connection, which appears in the application.|
|1042 - ER_BAD_HOST_ERROR|
Unable to connect to host. Please verify the host and port values.
|1045 - ER_ACCESS_DENIED_ERROR|
Credentials failed to connect. Please verify your credentials.
Set the following option in the connect string options:
|Prepared statement needs to be re-prepared.|
Database Cursor is not compatible with PREPARED statements in MySQL. The fix is to set the following in the Connect String Options:
For more information on error messages for this connection type, see https://dev.mysql.com/doc/refman/8.0/en/error-handling.html.