Skip to content
DataSquaresDocs
datasquares.aiSign inStart free

Connect DataDatabases

MySQL

You connect MySQL from the DataSquares connection wizard.

  1. In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.

  2. Pick MySQL on that page (search or browse by category).

  3. Fill in the connection details below, then test the connection and save.

Connection details

Section titled “Connection details”
Field What to enter
Host The hostname or IP address of your MySQL server.
Port Prefilled with 3306 (the MySQL default) — change it if your server listens elsewhere.
Database The database to connect to.
Username / Password Credentials for a user with read access to the tables you want to analyze.
TLS On by default: Use SSL/TLS encryption connects encrypted and verifies the server certificate. Tick Trust self-signed certificate for a private CA; turn TLS off only for a server that has none.

Grant the connection user read-only access — DataSquares only ever reads from your source.

Grant read-only access

Section titled “Grant read-only access”
CREATE USER 'datasquares'@'%' IDENTIFIED BY '********';
GRANT SELECT ON analytics.* TO 'datasquares'@'%';
FLUSH PRIVILEGES;

Scope '%' down to the DataSquares server’s IP where policy allows.

Common errors

Section titled “Common errors”

Test Connection shows a short summary, such as Authentication failed — check the username and password. The text below is what the database itself reports, for example in the SQL editor.

Error Cause / fix
Access denied for user 'x'@'host' MySQL grants are per-host — the user must be allowed from the DataSquares server’s address
Client does not support authentication protocol very old accounts using mysql_native_password mismatches — re-create the user on the server’s current default auth plugin
Unknown database the Database field is the schema name in MySQL terms
connection timeout port 3306 unreachable, or bind-address restricts the server to localhost
Section titled “Related”