MySQL

About

This CLI connection makes the MySQL client (mysql) and MySQL Shell (mysqlsh) available in the Sazabi agent's sandbox. The agent can use them to query and administer your MySQL databases. The tools are baked into the sandbox image; connecting them configures the connection for the already-installed CLIs.

Prerequisites

• A Sazabi project.
• MySQL connection details:
  • MYSQL_HOST — hostname or IP address of your MySQL server.
  • MYSQL_TCP_PORT — TCP port your MySQL server listens on (typically 3306).
  • MYSQL_USER — MySQL username.
  • MYSQL_PWD — MySQL password for the specified user.
• Optionally, MYSQL_DATABASE — the default database name to connect to.

Set up in the dashboard

Configure the sandbox in the dashboard under Settings > Sandbox CLIs.

Set up with the CLI

You can also configure the MySQL CLI connection with the Sazabi CLI (installed and authenticated — see CLI reference).

sazabi sandbox-clis set --type mysql --env MYSQL_HOST=<your-host> --env MYSQL_TCP_PORT=3306 --env MYSQL_USER=<your-user> --env MYSQL_PWD=<your-password>

To validate the credentials without saving, run the same command with test in place of set (the test command also requires the --env flags).

Verify

Ask the agent, in a thread, to run the mysql CLI (a read-only or status command) and confirm it returns real output. If the command is not found, the CLI connection may not be enabled; if it runs unauthenticated or cannot connect, recheck the credentials.

Troubleshooting

Command not found — Confirm the MySQL CLI connection is enabled for the project under Settings > Sandbox CLIs.

Authentication or connection fails — Recheck the credential/connection values under Settings > Sandbox CLIs.

Further reading