MySQL Forums
Forum List  »  MySQL Workbench

Problem connecting to mysql server with workbench
Posted by: Brian McGill
Date: September 06, 2022 04:59AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem connecting to mysql server with workbench
141
September 06, 2022 04:59AM


Sorry, only registered users may post in this forum.

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.