asked on

mysql connection failed 10061

I am running an Ubuntu server on Hyperv.
on my Ubuntu server I have my sql which I am able to connect to via mysqlworkbench

When I try to connect from the host machine using mysqlworkbench i am getting and error:

Failed to connect to mysql at 192.168.254.123 (which is my ubuntu server) with user root.
Can't connect to MySql on 192.168.254.123 (10061).

How do I resolve

plusone3055

That Generic error means the newwork connection has been refused

SQlWorkbench will only listen for local host connections

you will have to modify your .CNF file and comment out

bind-address 127.0.0.1

and then restart your SQL service

Dave Baldwin

SQlWorkbench will only listen for local host connections

Sorry but that's not true. MySQL Workbench will connect to remote database servers if you have the privileges to do. I have MySQL Workbench on this machine but my MySQL databases on not on this machine but on others including databases that are on the internet. It works fine.

plusone3055

@Dave My apologies. I stand Corrected I thought that was the default setting to only listen for LocalHost :(

Dave Baldwin

That's ok, I learn new things here all the time.

HalCHub

ASKER

so what does that mean ?

Dave Baldwin

Can you ping 192.168.254.123 from your host machine to make sure you can connect to it? Here is the general info on your error: http://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html

ASKER CERTIFIED SOLUTION

arnold

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial