The mysql error.log shows
[Warning] Aborted connection 320935 to db: '...' user: '...' host: '...' (Got an error reading communication packets)
While the client side get's:
Lost connection to MySQL server at 'reading initial communication packet', system error: 111 Lost connection to MySQL server at 'reading authorization packet', system error: 0 and after a while: Host '...' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
I read mysql manual about this, and a lot of other threads. So I changed some values in my.cnf
max_allowed_packet = 512M connect_timeout = 60 net_read_timeout = 120 innodb_buffer_pool_size = 5G
Looked at query log of a broken connection:
22400 Connect user@host on dbname 22400 Query SELECT @@sql_mode 22400 Query SET SESSION sql_mode='' 22400 Query SET NAMES utf8 22400 Init DB dbname 22400 Init DB dbname
Checked table status. bind-address is the server IP but I need to be able to connect from outside.
Aborted_connects is 196