Hi, I've been struggling with this problem for days and getting nowhere. My setup: Debian 8 ISPConfig 3.1.6 The mysql on port 3306 is LISTENING. I'm able to connect to the db correctly from LAN addresses but not remotely. I am able to connect to the server on port 3306 remotely via telnet. My my.cnf bind-address = 0.0.0.0 The username connecting is given % and all granted. All help is welcome!
Error message is: "Lost connection to MySQL server at 'reading authorization packet', system error: 2"
The error message above comes from MySQL Workbench Windows 10. Error message connecting from another Debian 8 machine with mysql reads: ""ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 2 "No such file or directory""
could be some timeout issue up to firewall ... does it take some time before receiving the error message? that could indicate mysql is doing name-lookup and dies trying due to incorrect dns try SET GLOBAL connect_timeout = 10; and/or add to my.cnf skip-name-resolve restart mysql-service ( the set global is not persistent, but shouldn't be needed if everything's working fine ) be aware that skip-name-resolve might break users specified to login from @localhost and so on, you either have to duplicate the users, allowing them to connect from 127.0.0.1 and so on or fix your dns settings
