I'm trying to connect to a MySQL db remotely for about 10 hours with no luck.
The server is running Debian.
my.cnf is configured correctly with
bind-ip 0.0.0.0 and no skip-networking.
lsof -i :3306 shows an established connection from the connecting IP to the server, but then dies off.
When using tcpdump port 3306 and '(tcp-syn|tcp-ack)!=0' on server I get this when trying to connect to it:
10:55:44.195273 IP server2.xxx.xxx.mysql > xxx.xxx.12.89.53920: Flags [R], seq 1740903883, win 0, length 0
The user connecting is granted all access from
I don't know what more to do. The server is running
bastille firewall but even with it off nothing works. I am able to connect to the db locally and LAN addresses.
This is what I get when I'm trying to connect to the db server:
"ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 2 "No such file or directory"
skip_name_resolve is on
bind address commented