HalCHub
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
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
SQlWorkbench will only listen for local host connectionsSorry 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.
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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