MySQL

Connect to MySQL so you can browse schemas, build queries, and (where supported) render spatial maps.

Goal

Create a working MySQL connection in Connection Manager.

Prerequisites

• Host name, port, database name, and credentials
• Firewall access from your workstation

Steps

1. Open Data → Connection Manager….
2. Add a connection and choose MySQL.
3. Enter connection details (host, port, database/service, user, password, and provider-specific options).
4. Click Test (or equivalent) to verify connectivity.
5. Save the connection.
6. On the Data tab, select the connection and open Query Builder to start a query.

[ Screenshot: MySQL connection settings ]

Notes

Note

The MySQL provider also supports MariaDB servers. See MariaDB.

Tip

Connection help text targets MySQL 8.0+ / MariaDB 10.6+ environments.

Result

The connection appears in Connection Manager and can be selected for queries and compatible map sources.

See Also

• Data Sources overview
• Query Builder
• Parameters
• MariaDB
• MySQL Spatial maps