MySQL常见的异常

1.ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)

首先尝试：

delete from mysql.user where user is NULL or user=‘‘;

commit;

上述方法无效！

解决方法：直接mysql回车即可~

2.Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect.

原因:MySql运行在safe-updates模式下，该模式会导致非主键条件下无法执行update或者delete命令。

解决方法：执行命令SET SQL_SAFE_UPDATES = 0;修改下数据库模式。

例如：

SET SQL_SAFE_UPDATES = 0;
delete from mysql.user where user is NULL or user=‘‘;

commit;

...

To Be Continued~

有空应该去看看官方的错误文档~

MySQL常见的异常

标签：