发布时间:2016-04-30 22:20:53
ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement mysql> set global read_only=off===================================================================================启动mysqld时报错: ERROR! The server quit without updat.........【阅读全文】
发布时间:2016-04-27 22:34:22
今天尝试用一台虚拟机去连另一台虚拟机的mysql时出现了报错.ERROR 1129 (HY000): Host'192.168.2.128' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'这是由于一个ip在短时间内产生太多中断的数据库连接导致的.解决: 1.增大连接数 #vi my.cnf&nb.........【阅读全文】
发布时间:2016-04-23 16:57:10
把一直尝试登录服务器的非法ip加入防火墙黑名单,可以按这个思路扩展为把攻击的ip加入防火墙黑名单。有问题欢迎指教,感恩啦。#!/bin/bash##block the illegal ip that attempt to access server###1.get the illegal ipcat /var/log/secure |grep 'Failed password for root'| awk '{print $11}' | uniq -c|awk.........【阅读全文】