can't connect to MySQL remotely on Windows 10

Asked Mar 22 '21 at 00:58

Active Mar 22 '21 at 08:09

Viewed 61 times

I already edited my config, bind-address = 0.0.0.0 I also granted privileges on existing accounts to allow remote access, made sure I was connecting to port: 3306, I also allowed inbound and outbound connection of port: 3306.

I checked my MySQL status it says connection: localhost via TCP/IP and I still can't connect to my MySQL remotely. Any help? Thanks!

I'm running Windows 10

EDIT: I also check on netstat, port 3306 is running and listening. Also configured the "port forwarding" on my router (local IP:port 3306)

edited Mar 22 '21 at 08:09

asked Mar 22 '21 at 00:58

000Luck

no, I forgot to mention I used netstat and saw port 3306 is listening – 000Luck Mar 22 '21 at 01:04
Nothing was listening at the IP:port you tried to connect to. This is the meaning of the error. – user207421 Mar 22 '21 at 01:07
Like I said, I used `netstat` and got this result `Local address 0.0.0.0:3306`, what could be the problem? – 000Luck Mar 22 '21 at 01:12
So you must have used the wrong IP:port from the remote host. – user207421 Mar 22 '21 at 01:13
I used my IP from https://www.whatsmyip.org/ which is my public IP address , but when I use my local IP (starts with 192.168) it works. – 000Luck Mar 22 '21 at 01:16
So you need to arrange port forwarding from your router to this host for 3306. – user207421 Mar 22 '21 at 01:18
@user207421 Yeah, I configured my router to forward it to my internal IP, still no luck. – 000Luck Mar 22 '21 at 01:23

can't connect to MySQL remotely on Windows 10

0 Answers0