MySQL Forums
Forum List  »  MySQL Workbench

Re: Able to connect to remote MYSQL DB with heidi-sql but not mysql-workbench
Posted by: Joshua Wilkeson
Date: March 07, 2022 09:48AM

Joshua Wilkeson Wrote:
-------------------------------------------------------
> 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?

Including more information with this:

- The remote server is using mysql Ver 14.14 Distrib 5.1.73, for Win64
- My machine is using mysql-workbench-community ver 8.0 and mysql ver 8.0.28-0ubuntu0.20.04.3 for Linux on x86_64 (Ubuntu)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Able to connect to remote MYSQL DB with heidi-sql but not mysql-workbench
186
March 07, 2022 09:48AM


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.