MySQL Studio - Configuration Options
Overview
MySQL Studio includes a set of configuration options that control application behavior, security, network access, resource limits, and user management. These settings can be tailored to specific deployment requirements by overriding the system environment variables directly on the service.
To override the environment variable for the
mysql-ai-studio systemd service, run
systemctl edit mysql-ai-studio and add
Environment="MYDAS_LISTEN_ADDRESS=0.0.0.0:8080"
under the [Service] section in the editor.
After saving the changes, execute
systemctl daemon-reload and
systemctl restart mysql-ai-studio to apply
the new environment variable and restart the
service.
Environment Variables
| Environment Variable | Default | Description |
|---|---|---|
| MYDAS_LOG_LEVEL | debug | Controls the logging verbosity for the application. |
| MYDAS_SSL_DIR | /opt/mydas/certs/ | Path to directory containing SSL/TLS certificates and keys. |
| MYDAS_USERS_DIR | /opt/mydas/data/users/ | Path to a directory containing the user scratch spaces. |
| MYDAS_USERS_VOLUME | /opt/mydas/data/users/ | Path to a directory containing the user scratch spaces. |
| MYDAS_LISTEN_ADDRESS | 127.0.0.1 | IP address for the server to listen on for incoming connections. |
| MYDAS_PODMAN_PYTHON_CPUS | 1 | Number of CPUs allocated to the Python container. |
| MYDAS_PODMAN_PYTHON_PIDS_LIMIT | 500 | Maximum number of process IDs in the Python container. |
| MYDAS_PODMAN_PYTHON_MEMORY | 1024m | Amount of memory allocated to the Python container. |
| MYDAS_SESSION_KEY_HEX | (none) | Session key (in hexadecimal) used for signing or encryption purposes. |
| MYDAS_LIMIT_FILE_UPLOAD_BYTES | 5 MiB | Maximum allowed size for file uploads in bytes. |
| MYDAS_SESSION_EXPIRATION_SECONDS | 43200 | Expiration time for sessions in seconds. |
| MYDAS_SQL_CONNECTION_ENCRYPTION_MODE | ENCRYPTED_UNVERIFIED | Controls the encryption mode for SQL connections. |
| MYDAS_SQL_CONNECTION_PORT | 3306 | Port number for SQL connections. |
| MYDAS_SQL_RESPONSE_SIZE_MAX_KIB | 64 | Maximum size of SQL responses in kibibytes (KiB). |
| MYDAS_PORT | 8282 | Port numbers for the application. |
| MYDAS_LIMIT_PYTHON | 10 | Number of Python containers. |