When you create or update a MySQL connection, you can configure additional attributes, such as the connection ID and the connection name.
The following table describes attributes that you can use for MySQL connections:
| Attribute | Description |
|---|---|
| id | Connection ID |
| orgid | Organization ID. |
| name | Connection name. |
| description | Optional connection description. |
| type | Connection type. Use MySQL. |
| username | User name for the database login. |
| password | Password for the database login. |
| host | Name of the machine hosting the database server. |
| port | Network port number used to connect to the database server. Default is 3306. |
| database | Database name for the MySQL database target. Database name is case sensitive if the database is case sensitive. |
| codepage | The code page of the Microsoft SQL Server database. Use one of the following options: UTF-8. Unicode Transformation Format, multibyte. MS1252. MS Windows Latin 1 (ANSI), superset of Latin 1. ISO-8859-15. Latin 9, Western European. ISO-8859-2. Eastern European. ISO-8859-3. Southeast European. ISO-8859-5. Cyrillic. ISO-8859-9. Latin 5, Turkish. IBM500. IBM EBCDIC International Latin-1. |
| agentid | Secure Agent ID |