Connection to SQL via remote clients

Submitted by masterg0g0 on Sun, 03/27/2016 - 14:36 Pro Licensee

Hello there, I have been trying to connect one of our clients to this server via SQL workbench.. but someone not been able to get this to work. I have the port setup in the firewal rule to allow port 3306.

but the connections fail with error (10061)

Can you give us some pointers pls..

Thanks, Rohit

Status: 
Closed (fixed)

Comments

Submitted by andreychek on Sun, 03/27/2016 - 14:44

Howdy -- is this server behind a NAT router, or directly on the Internet?

Also, what is the output of this command:

netstat -an | grep :3306

Lastly, you would need to make sure that the particular user who you're attempting to log in as has permissions to access MySQL from their IP address.

To do that, you can go into Edit Databases -> Remote Hosts, and there, you can add the IP address that they will be connecting from.

Submitted by masterg0g0 on Sun, 03/27/2016 - 16:48 Pro Licensee

Hello the server is not NATed and is directly on the internet. Also the remote hosts were enabled for atleast to being with my PCs external IP. Output of command: $ netstat -an | grep :3306 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN

Ok solution: it seems that the SQL was only listening to localhost, i enabled to listed on all ports.. and vallah.. it works.. Closing this ticket thanks for the pointers.

Submitted by masterg0g0 on Sun, 03/27/2016 - 16:48 Pro Licensee

Status: Active ยป Fixed

Submitted by andreychek on Sun, 03/27/2016 - 17:19

Great, glad to hear it's working now!

Setting up a remote host is supposed to change MySQL to listen on external interfaces. It doesn't sound like that happened in this case, I'll look more into that. But it's good that it's working now.

Please feel free to let us know if you have any additional questions!