MySQL Related Help

Top Previous Next

Last update: 2026-07-01

In this part of the Database Workbench help you will find all MySQL specific items. This includes screenshots, specialized editors and settings and the meaning of general settings for MySQL related tasks.

Quick links:

•	Registering a MySQL Server

•	Create a Database

•	Using the Server Manager with MySQL

•	Using the Database Navigator with MySQL

Limitations

MySQL is a bit different from the other available database engines in Database Workbench, the following limitations apply:

Transactions

MySQL doesn't support transactions, except for certain storage engines (InnoDB, Berkeley DB, Falcon). Changes will be autocommitted unless you start a transaction yourself.

Because of this, you need to explicitly start a transaction in the SQL Editor or Table Editor (Data tab) if you want to preserve current data or run an UPDATE or DELETE statement if you want to make sure you can rollback. The transaction itself only has effect on those storage engines that supports transactions.

Constraints

•	Currently, only the InnoDB storage engine supports Foreign Key constraints. All other storage engines only support Primary Key or Unique Constraints, Check Constraints are not supported.