Avatar of ClintonK
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Cannot connect to MySQL on remote server

I have a virtual server running Ubuntu 14.04 and MySQL. The server is a new build specifically to test this connectivity. I have installed MySQL Workbench 6.1 CE on my Windows 7 64bit Pro desktop. Both the PC and the Ubuntu server are on the same network.
The Ubuntu server is on and my PC is on
When I try to connect to MySQL using the Workbench with username "root" and password <mypassword> and then "Test Connection" I get error "Failed to connect to MySQL at with user root"
I have tried running the following on the MySQL server but still it won't connect.
GRANT ALL ON *.* to 'root'@'%' IDENTIFIED BY 'mypassword';    

No firewall is running on the PC or the Ubuntu server

Avatar of undefined
Last Comment
Ruel Tmeizeh

8/22/2022 - Mon
Ruel Tmeizeh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

You were exactly right! Editing the file has cured the problem. (it took me a while to test because I'd managed to lock myself out of root access to MySQL so had to sort that first :-/ )
Thanks, I've spent many hours surfing for the solution and never even got close to that one.
Ruel Tmeizeh

Great! Glad to hear that fixed it.
God bless.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy