Common exceptions for MySQL

1.ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

First try:

Delete from Mysql.user where the user is NULL or user= ';

Commit

The above method is invalid!

Workaround: Direct MySQL enter can ~

2.Error code:1175. You is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column to disable safe mode , toggle the option in Preferences, SQL Queries and reconnect.

Cause: MySQL runs in safe-updates mode, which causes the update or delete command to not be executed under a non-primary key condition.

Workaround: Execute command set sql_safe_updates = 0; Modify the database schema below.

For example:

SET sql_safe_updates = 0;
Delete from Mysql.user where the user is NULL or user= ';

Commit

...

To be continued~

Have time to see the official error document ~

Common exceptions for MySQL