Avatar of ClintonK
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 192.168.1.15 and my PC is on 192.168.1.100
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 192.168.1.15 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';    
FLUSH PRIVILEGES;

No firewall is running on the PC or the Ubuntu server
Linux

Avatar of undefined
Last Comment
Ruel Tmeizeh

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
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
or
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
ClintonK

ASKER
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.
Cheers
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