MySQL Workbench notes

  • When exporting for MariaDB 10.4, make sure to turn GTID to off in the export advanced option tab. (command line:  –setgtid-purged=OFF).  The default is AUTO and importing the resulting export file will result in “unknown system variable”.
  • If encounter error code 1175 while deleting rows from table, Workbench defaults to safe mode for deleting.  Do the following to get around it: