# MySQL\_ConnectionString

## `MySQL_ConnectionString` (FB)

FUNCTION\_BLOCK MySQL\_ConnectionString

**Short description:**

> This function block contains the login and server information.

**Detailed description:**\
The function block must be defined once in the PLC program. It stores all parameters of the other MySQL-FBox instances.

**Attention:** For stable functionality this function block should not be "called" within the PLC program.

InOut:

| Scope | Name                  | Type                                                       | Comment                                                                                |
| ----- | --------------------- | ---------------------------------------------------------- | -------------------------------------------------------------------------------------- |
| Input | `xConnected`          | `BOOL`                                                     | TRUE: Successfully connected and logged in.                                            |
| Input | `sHost`               | `STRING`                                                   | MySQL server host address as hostname or IP address                                    |
| Input | `uiPort`              | `UINT`                                                     | MySQL server port (Default: 3306)                                                      |
| Input | `sUsername`           | `STRING`                                                   | MySQL database username                                                                |
| Input | `sPassword`           | `STRING`                                                   | MySQL database user password                                                           |
| Input | `sDatabase`           | `STRING`                                                   | MySQL database schema name                                                             |
| Input | `stServerInfo`        | MySql\_ServerInfo                                          | <p>MySQL server information which are stored in the<br>MySQL\_ServerInfo structure</p> |
| Input | `hInternalSocket`     | `RTS_IEC_HANDLE`                                           | <p>internal\_SocketHandle : \_\_XWORD;<br>// Socket handler</p>                        |
| Input | `internal_SemaBuffer` | `__XWORD`                                                  | sema buffer                                                                            |
| Input | `abTxBuffer`          | <p>ARRAY<br>\[0..gc\_MySQL\_dwTxBufferSize]<br>OF BYTE</p> | Transmit buffer                                                                        |
| Input | `abRxBuffer`          | <p>ARRAY<br>\[0..gc\_MySQL\_dwRxBufferSize]<br>OF BYTE</p> | Receive buffer                                                                         |