Re: Able to connect to remote MYSQL DB with heidi-sql but not mysql-workbench

[Joshua Wilkeson]

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)