MySQL

This guide explains how to connect to MySQL databases with Oxygen. MySQL is one of the world’s most popular open-source relational database management systems.

Configuration Options

Add your MySQL configuration to config.yml. Here are all available parameters:

databases:
  - name: my_mysql_db # Unique identifier for this connection
    type: mysql
    host: "localhost" # MySQL server hostname or IP
    port: "3306" # Port number (default: 3306)
    user: "root" # Username for authentication
    password: <password> # Direct password (not recommended)
    password_var: "MYSQL_PWD" # Environment variable containing password (recommended)
    database: "default" # Database name to connect to

Example Configurations

Prepare password environment variable

Export the environment variable:

export MYSQL_PWD=<your password>

Or put it in .env file:

echo MYSQL_PWD=<your password> >> .env

Add MySQL configuration

databases:
  - name: local_db
    type: mysql
    host: "localhost"
    port: "3306"
    user: "dev_user"
    password_var: "MYSQL_PWD"
    database: "development"

Troubleshooting

Verify MySQL server is running: mysqladmin ping
Check connectivity: mysql -h hostname -u username -p
Common ports: 3306 (default), 33060 (X Protocol)
Ensure user has proper permissions: SHOW GRANTS

Get started

Data Infrastructure

World Model

Agentic Intelligence

SDK

Automations

Data Apps

Integrations

Edge fleet

Manage

Workspaces

Authentication

Observability

Enterprise

Reference

REST API

Resources

Troubleshooting

Configuration Options

Example Configurations

Troubleshooting

​Configuration Options

​Example Configurations

​Troubleshooting

Configuration Options

Example Configurations

Troubleshooting