When performing UPDATE and DELETE operations in Mysql, an error number 1175 occurs because the safe mode is not enabled. The solution is as follows:

SET SQL_SAFE_UPDATES = 0;

After performing UPDATE and DELETE operations, it is recommended to reopen the safe mode:

SET SQL_SAFE_UPDATES = 1;

What is safe mode:
A mode in which UPDATE or DELETE commands cannot be executed under non-primary key conditions.
The security mode query can be performed by the following statement:

SHOW VARIABLES LIKE 'SQL_SAFE_UPDATES';