Able to connect to remote MYSQL DB with heidi-sql but not mysql-workbench
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?
Subject
Views
Written By
Posted
Able to connect to remote MYSQL DB with heidi-sql but not mysql-workbench
1073
March 06, 2022 10:43AM
443
March 06, 2022 04:08PM
440
March 07, 2022 11:29AM
648
March 07, 2022 09:48AM
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.