MySQL bug 整顿

整顿了一些遇到过的报错信息

1. 近程连贯服务器数据库报错：

   Host‘XXXXXX’is blocked because of many connection errors. 

   Sol:

   show global variables like‘%max_connect_errors%';
   set global max_connect_errors=1000000;

   然而这不是问题的基本解决办法，只能一时无效，永恒无效可参考以下文章：
   https://blog.csdn.net/li_li_l…

2. 跟权限相干的报错

   ERROR 1290 (HY000): The MySQL server is running with the —skip-grant-tables option so it cannot execute this statement. 

   Sol:

   刷新权限列表 flush privileges;
   赋予权限：grant all privileges on . to USER@’%’identified by ‘password’;

3. SQL 语句过长导致执行失败
   Sol:

   更改最大限度

   set global max_allowed_packet = 6*1024*1024;