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
LVL 1
HalCHubAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

plusone3055Commented:
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 BaldwinFixer of ProblemsCommented:
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.
plusone3055Commented:
@Dave My apologies.  I stand Corrected  I thought that was the default setting to only listen for LocalHost :(
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Dave BaldwinFixer of ProblemsCommented:
That's ok, I learn new things here all the time.
HalCHubAuthor Commented:
so what does that mean ?
Dave BaldwinFixer of ProblemsCommented:
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
arnoldCommented:
the default root user account in mysql can only be accessed/used from localhost, you need to add another account root@% OR root@remotehost to be able to use it from the remotehost or from any host.

My suggestion is to create a new account and grant the rights it needs, or associate it with a specific database
authentication when the account has all rights is username/password when account lacks mysql security rights, authentication is username/password/database.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.