--- title: "Connecting to MySQL or MariaDB" slug: "connecting-to-mysql-or-mariadb" updated: 2026-07-06T15:29:08Z published: 2026-07-06T15:29:08Z canonical: "skthelp.syniti.com/connecting-to-mysql-or-mariadb" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Connecting to MySQL When connecting to a MySQL database from the Syniti Knowledge Platform (SKP), provide the following connection properties to establish a secure and reliable connection. This article explains each property to understand what information is required and how it is used. | **Property** | Description | Notes | | --- | --- | --- | | **Name** *(Required)* | Name of the MySQL connection unique to the SKP. | NA | | **Description** | Enter a description that briefly states the purpose of this connection. | NA | | **Hostname** *(Required)* | Hostname is the network name or IP address of the MySQL server you want to connect to. | * The server name, for example, MySQLPROD01. * An IP address, for example, 192.168.10.50. | | **Port** | The port number your MySQL uses to accept connections. | By default, the MySQL port is **3306**. If you are not sure, you can use this default port. | | **Username** *(Required)* | The login name used to sign in to the MySQL. | This login name should be an account that your administrator has created for database access. | | **Password** *(Required)* | The password for the username above. | Authenticates your connection to the database. | | **Database** | The name of the specific MySQL database you want to connect to. | MySQL can have many databases; this tells the SKP which one to use. | | **Connection Timeout** | The maximum number of seconds the system will wait when trying to connect before stopping and showing an error. | Default value is **60 seconds**. If your server is slow or far away, you can raise this number. | | **Connection Pooling** | Connection pooling allows the system to reuse existing database connections instead of creating a new one every time the SKP performs an operation. | * **Enabled (Default):** The SKP keeps a group (pool) of open database connections ready to use. This reduces the time spent opening and closing connections. * **Disabled:** A new connection is created and closed for each operation. This is simpler and uses fewer system resources but can be slower for frequent operations. | | **Minimum Pool Size** | The minimum number of connections that the system will always keep open when pooling is enabled. | Even if the SKP is idle, it will maintain at least this number of ready-to-use connections. Useful when you expect regular activity and want faster response times. For example, If Minimum Pool Size = 2, the SKP always keeps at least 2 connections open. | | **Maximum Pool Size** | The maximum number of connections the SKP is allowed to open when pooling is enabled. | This prevents the system or database from being overloaded with too many connections. When the pool reaches this limit, new requests must wait until a connection is released. For example, If Maximum Pool Size = 10, the SKP never opens more than 10 connections at the same time. | | **SSL Mode** | Mode for controlling the SSL connection. | **Disabled:** SSL is not used. **Preferred:** The client first attempts an SSL connection; if that fails, it falls back to a non-SSL connection. **Required:** The connection must use SSL; if an SSL connection cannot be established, an error is returned. **Verify-CA:** SSL is required, and the server certificate must be verified against a trusted Certificate Authority (CA). **Verify-Full:** SSL is required, the server certificate must be verified against a trusted CA, and the server hostname must match the certificate. | | **SSL Client Private Key** | The PEM-encoded private key corresponding to the client certificate. | Required when a client certificate is provided. | | **Extended Properties** | Use the **+ Add Property** button to add any additional connection properties. | NA | ## Related Articles [Create a Connection](/v1/docs/create-a-connection)