Problem connecting to mysql server with workbench
Hi, I am trying to connect to a mysql server on an ubuntu laptop, via a windows desktop running workbench, over the internet.
I am able to run workbench on the ubuntu laptop without any problems.
When I try to connect using the windows desktop, clicking the test connection, I get the error message failed to connect to mySQL at:x.x.x.x:3306 with user desktop. Unable to connect to localhost.
I have checked the ip address. I can ping the ubuntu laptop from my desktop. I have allowed connections to port 3306 on the laptop with the ubuntu command: 'sudo ufw allow 3306'. I put the ipaddress for the desktop in the limit to hosts matching for the user. I have temporarily switched the desktop firewall off. Still I get the same error message.
Any ideas on how to fix the problem?
Brian.
Subject
Views
Written By
Posted
Problem connecting to mysql server with workbench
1952
September 06, 2022 04:59AM
935
September 06, 2022 05:48AM
628
September 06, 2022 07:06AM
499
October 26, 2022 04:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.