​MySQL is the open-source relational database management system hosted either in the cloud or on-premise. The MySQL Connector, once known as MyODBC, is computer software from Oracle Corporation. It has Open Database Connectivity (ODBC) interface and allows programming languages that support the ODBC interface to communicate with a MySQL database.
For your MySQL account, YAP ensures the following actions:
Create row
Read row
Update row
Find row
Delete row
Count row
Run custom SQL action
List of fields available for Create row action in MySQL connector:
Field | Type |
Table | String |
Values | Object |
List of fields available for Read row action in MySQL connector:
Field | Type |
Table | String |
Condition | Object |
Values | Object |
Attributes | Object |
Limit | Number |
Order by | String |
Order way | Desc or Asc |
List of fields available for Update row action in MySQL connector:
Field | Type |
Table | String |
Condition | Object |
Values | Object |
List of fields available for Delete row action in MySQL connector:
Field | Type |
Table | String |
Condition | Object |
List of fields available for Count row action in MySQL connector:
Field | Type |
Table | String |
Condition | Object |
List of fields available for Run custom SQL action action in MySQL connector:
Field | Type |
Code | Function |
Before setup, please check that you have granted to YAP the permission to send notification to your MySQL account. For this, sign in to MySQL and authorize the permissions requested by YAP.
The MySQL connector allows querying in an external MySQL database.
Field | Type | Description |
Host | Required | The IP address or hostname (db.example.com) of where your database instance resides. Note, |
Port | Required | Number field. Values will be converted into a number. |
Database | Required | The name of the database you would like to interact with. |
Username | Required | We recommend creating a new database user with extremely limited access. |
Password | Required | Again, this should not be your production password. Make it strong! (We like using random.org.) |
SSL Client Certificate | Optional | Required for SSL. Provide the contents of the client certificate file in PEM format. The certificate's Common Name (CN) must match the Host provided above. The certificate must be issued by a public CA and all CA certificates needed to establish the certificate's authenticity must be included. Self-signed certificates are not supported. For details see Python's documentation on Certificates. |
SSL Private Key | Optional | Required for SSL, but it may also be part of the SSL Client Certificate as long as it comes first. Provide the contents of the private key file. The private key may not be encrypted. |
Questions? We're always happy to help with any issues you might have! Send us an email to support@youngapp.co or request the demo with our sales team.