MySQL

MySQL is generally available in the DataSquares connection wizard.

1. In DataSquares, open Data Sources and choose Add data source.

2. Pick MySQL in the connector picker (search or browse by category).

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

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	Enable if your server requires an encrypted connection.

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

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

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

Related

• Connector catalog — everything DataSquares connects to.
• Quickstart — from connection to shared dashboard.