MySQL Delete and modify data error 1175

When you perform a batch update of a database with MySQL Workbench, executing a statement encounters the following error message:

Error code:1175

You is using Safe...without a WHERE that uses a KEY column

Because it is the default security setting for MySQL Workbench, the table cannot be updated in bulk. This error is prompted when the SQL statement to be executed is a batch update or delete.

Here's how to fix it:

Open the Workbench menu [edit]->[preferences ...]
Switch to the [SQL Editor] Page
Remove the checkmark before [forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]
Click the [OK] button
Finally, remember to restart SQL editor and create a new connection.

MySQL Delete and modify data error 1175