Tuesday, December 25, 2007

MYSQL 4/5 ERROR : Host 'SERVER' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

masukkan dalam my.cnf atau my.ini ( windows ) bawah [mysqld]

max-connect_errors = 9999999999999
max_error_count = 9999999999999
max_user_connections = 9999999999999
skip-host-cache
restart mysqld

perlu flush juga host tapi boleh buat cronjob / schedule task ( windows )
buat skrip utk run:-

mysqladmin -u root -p flush-hosts

No comments:

 Simple Python Calculator This script will allows your to calculate the integers given with the chosen operation. You can add, substract, mu...