Is there anything you would like to know?
What should I do if my MySQL appears error code 1175?

This is due to the security settings of Workbench, which can be solved through settings. Please refer to the following two methods:

 

Option 1: Express settings

 

Enter "SET SQL_SAFE_UPDATES = 0;" in the query window of Workbench.

 


Option 2: Interface settings

 

  1. In the feature column of Workbench, click "edit > Preferences", and "Workbench preferences" dialog box will pop up.

     
  2. In the left column of "Workbench", click "SQL Editor" and you will see "Safe Updates..." checked in the last line, just uncheck it.

     
  3. When unchecked, you may find you cannot click "OK" button in Linux system. Please click "General Editors" option in the left column, then you will be able to click "OK" button.

     
  4. Restart workbench.

Couldn't find the answer you need?

Contact our support team.