<div dir="ltr">I've been fiddling around with things on my home LAN and got into a situation where my Frontend kept having connection errors with the separate Backend. Once I'd got things back to the way they were on the LAN, I could still no longer get a connection. So I tried to telnet to backend port 3306 from the frontend and got this error:<div>
<br></div><div><div><font face="courier new, monospace">$ telnet 192.168.0.120 3306</font></div><div><font face="courier new, monospace">Trying 192.168.0.120...</font></div><div><font face="courier new, monospace">Connected to 192.168.0.120.</font></div>
<div><font face="courier new, monospace">Escape character is '^]'.</font></div><div><font face="courier new, monospace">hHost 'mfe1.local' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.</font></div>
</div><div><br></div><div>I then logged into mysql as root on the backend and issued" flush hosts" command. But the frontend still can't connect to the backend, even though I can now get a telnet connection on port 3306:</div>
<div><br></div><div><div><font face="courier new, monospace">$ telnet 192.168.0.120 3306</font></div><div><font face="courier new, monospace">Trying 192.168.0.120...</font></div><div><font face="courier new, monospace">Connected to 192.168.0.120.</font></div>
<div><font face="courier new, monospace">Escape character is '^]'.</font></div><div><font face="courier new, monospace">[</font></div><div><font face="courier new, monospace">5.5.35-0ubuntu0.12.04.2▒\yk-;!3▒/w.y;W%QJ`"&mysql_native_password</font></div>
</div><div><br></div><div>I'm now in that eternal loop where the frontend asks for hostname, DB name, DB user etc (the "Database Configuration" screens) but it can't connect when you click the Finish button so it loops round again to have another go.</div>
<div><br></div><div>I would have thought if the telnet connection is working it would all be OK. Any idea how I can resolve this?</div></div>