The Mysql data source enables interaction with a MySQL server. With this data source, app developers can access databases, execute queries and integrate data into their apps.
You can establish a connection using the connection parameters, such as host, port, and login information (user and password). You can then use SQL queries to retrieve, insert, update, or delete data.
Good to know
The data source can also be used for compatible systems such as MariaDB.
Parameters
|
Type |
Name |
Description |
|---|---|---|
|
TEXT |
host |
Specifies the server address of the MySQL server. |
|
NUMBER |
port |
Specifies the port to which the MySQL server is listening on the server. |
|
TEXT |
user |
Specifies the user to establish the connection. |
|
PASSWORD |
password |
Specifies the password of the specified user. |
|
TEXT |
database |
Specifies the database that is selected when the connection is established. |
|
TEXT |
encoding |
Specifies the encoding. With the empty value, utf8mb4 is used as the encoding for the connection. |