Skip to main content

MySQL

Connect a MySQL database to DashX. Once installed, you can sync its schema into Resources and read and write its records through the DashX API.

Prerequisites​

Prerequisites

Before setting up the MySQL integration, ensure you have:

  • An active DashX account
  • A running MySQL server reachable from the internet
  • Credentials for a database user DashX can connect as

Prepare a database user​

Create a dedicated user for DashX rather than reusing an application or root account. Grant it only what it needs — read access if you only intend to query, plus write access if you want to modify records through DashX.

CREATE USER 'dashx'@'%' IDENTIFIED BY 'a-strong-password';
GRANT SELECT ON your_database.* TO 'dashx'@'%';
FLUSH PRIVILEGES;

If DashX should also write records, add the relevant privileges:

GRANT INSERT, UPDATE, DELETE ON your_database.* TO 'dashx'@'%';
FLUSH PRIVILEGES;

Allow network access​

Your database must accept connections from DashX. Depending on where it is hosted this may mean adjusting a firewall rule, a security group, or the provider's list of allowed addresses.

Connect to DashX​

  1. Log in to your DashX workspace
  2. Navigate to Settings > Integrations
  3. Click [+] to add a new integration and select MySQL
  4. Choose the environments you want to enable it for
  5. Enter the configuration below and save

Configuration​

FieldDescription
HostHostname or IP address of the MySQL server.
PortPort the server listens on. MySQL defaults to 3306.
UserThe database user DashX connects as.
PasswordPassword for that user.
Database NameThe database to connect to.

Sync your schema​

With the integration installed, open Data > Overview and choose Sync Database to read the schema and turn tables into resources. See Resources for the full flow.

Related: the Database Hub app.