ERROR 1129 (00000) Host * is blocked because of many connection errors; unblock with ‘mysqlad解决

数据库连接有时会出现ERROR 1129 (00000) Host * is blocked because of many connection errors; unblock with ‘mysqlad问题，网上查询为对mysql错误操作过多，导致ip访问受限，处理方法：在mysql执行 flush hosts 命令

附加问题

访问数据库时出现：mysql: unknown variable 'server-id=1' 问题

主要是因为[mysql]、[mysqld]等标签范围设置错误导致，我将server-id属性从[mysql]移到[mysqld]即可

参考：

http://blog.csdn.net/edwzhang/article/details/5873838

http://blog.sina.com.cn/s/blog_69cc2f0b0100yx6i.html

http://www.jb51.net/article/48082.htm