Database guides

MySQL

This guide walks you through connecting a MySQL database to Sheeta AI. You can connect to local MySQL servers or cloud-hosted databases.

Connect to the database

Step 1: Open connection settings

Click the edit icon next to the connection dropdown to open the connection settings.

Step 2: Add a new connection

Click Add connection and select MySQL. You can configure the connection using individual fields or a connection URL.

Fill in your connection details:

  • Connection Name - A memorable name for this connection
  • Host - The server address (e.g., localhost)
  • Port - Usually 3306 (the default MySQL port)
  • Database - The name of your database
  • Username - Your database username (e.g., root)
  • Password - The user's password (optional)
MySQL connection form in Sheeta AI

Step 3: Test and save

Click Test Connection to verify everything works. Once successful, click Save.

Local MySQL setup

If you need to set up a local MySQL server for development, here are common approaches:

Run MySQL in a Docker container:

docker run --name mysql \
  -e MYSQL_ROOT_PASSWORD=password \
  -e MYSQL_DATABASE=mydb \
  -p 3306:3306 \
  -d mysql:8

Connection credentials:

  • Host: localhost
  • Port: 3306
  • Database: mydb
  • Username: root
  • Password: password

Troubleshooting

Connection refused

Check that MySQL is running and the port is correct (default 3306).

Access denied

Verify your username and password. Ensure the user has permission to access the specified database.