MySQL Forums
Forum List  »  MySQL Workbench

Able to connect to remote MYSQL DB with heidi-sql but not mysql-workbench
Posted by: Joshua Wilkeson
Date: March 06, 2022 10:43AM

I'm trying to connect to the mysql db for a remote server, I'm on Ubuntu 20.04, the remote server is using Windows 10. I'm using the same credentials for both clients but only heidisql-wine is able to connect successfully, the "Settings tab" for heidi-sql shows as

- Network type: MariaDB or MySQL (TCP/IP)
- Library: libmariadb.dll
- Prompt for credentials: unchecked
- Use Windows authentication: unchecked
- Compressed client/server protocol: unchecked
- Use SSL: unchecked

In MySQL-workbench my relevant settings are

- Connection Method: Standard (TCP/IP)
- Use SSL: If available
- Use compression protocol: unchecked
- Use ANSI quotes to quote identifiers: unchecked
- Enable Cleartext Authentication Plugin: unchecked
- Timeout: 60
- SQL_MODE: blank
- Others: sshCompressionLevel=0

To reiterate, I have the same credentials for both clients and the above settings but only heidisql-wine is able to connect but not mysql-workbench-community (most recent version), when testing the connection it gives me an error: "Failed to Connect to MySQL at my_ip:port with user" and on the next line "Unable to connect to localhost"

My question is: is there a setting in mysql-workbench that I'm missing which would allow me to connect to the remote server?

Options: ReplyQuote


Subject
Views
Written By
Posted
Able to connect to remote MYSQL DB with heidi-sql but not mysql-workbench
259
March 06, 2022 10:43AM


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.