BroadSQL Download
On this page
Documentation / Connect to your database: MySQL and MariaDB

Connect to MySQL and MariaDB

Add the vendor's Connector/J driver once, then connect with a URL that names the server and the database.

DriverNot bundled: download MySQL Connector/J or MariaDB Connector/J and copy its JAR into drivers.
URL formatjdbc:mysql://<host>:<port>/<database>
Examplejdbc:mysql://dbhost:3306/mydb
Where the URL format comes fromMySQL Connector/J: Connection URL Syntax, checked October 17, 2026
Verified with BroadSQLNot verified with BroadSQL by the BroadSQL team: the URL formats come from the MySQL and MariaDB documentation.

Which driver and which type

ServerDriver to copy into driversType to chooseURL format
MySQLMySQL Connector/J ("Platform Independent")MySQLjdbc:mysql://<host>:<port>/<database>
MariaDBMariaDB Connector/JMariaDBjdbc:mariadb://<host>:<port>/<database>

The default port of both is 3306. The MariaDB URL format is documented in About MariaDB Connector/J (checked October 17, 2026); the MariaDB driver accepts only jdbc:mariadb: URLs unless the option permitMysqlScheme is added.

Steps

  1. Copy the driver JAR into drivers and restart BroadSQL; SHOW DRIVERS; must list it.
  2. ADD CONNECTION SHOP_QA; (or CONFIG; on Windows), type MySQL (or MariaDB), URL jdbc:mysql://dbhost:3306/mydb (or jdbc:mariadb://dbhost:3306/mydb), then your user and password.
  3. PING SHOP_QA;, then CONNECT SHOP_QA;.

Driver options are added after ?, separated by &: see the vendor's documentation for encryption and time zone options.

On MySQL and MariaDB

  • A DDL statement (CREATE, ALTER, DROP) commits the open transaction on MySQL. In a Production Environment, the confirmation question says so.
  • SET PASSWORD does not change a MySQL or MariaDB password: change it in the database, then update BroadSQL with EDIT CONNECTION.

Found something wrong or unclear on this page? , with the page address.