Link to home
Create AccountLog in
Avatar of HalCHub
HalCHubFlag for United States of America

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
Avatar of plusone3055
plusone3055
Flag of United States of America image

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
Avatar of 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.
@Dave My apologies.  I stand Corrected  I thought that was the default setting to only listen for LocalHost :(
That's ok, I learn new things here all the time.
Avatar of HalCHub

ASKER

so what does that mean ?
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
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer