For the same mysql server, Sequel-Pro can connect but Sequel-Ace cannot

[xgfone]

• Sequel Ace Version (including build number): 4.0.13 Build 20062
• Sequel Ace Source (App Store/GitHub/Homebrew): App Store
• macOS Version: 11.7.10
• Processor Type (Intel/Apple): Intel
• MySQL Version: 5.6.31 & 5.7.19
• macOS Localization: English

Is Issue Present in Latest Beta?

I don't known.

Description
I had deployed two mysql servers on the remote host: 5.6.31 & 5.7.19.

I can use Sequel-Pro to connect to them, but Sequel-Ace cannot and reports the error as follow:

Unable to connect to host x.x.x.x because access was denied.
Double-check your username and password and ensure that access from your current location is permitted.
MySQL said: Access denied for user 'root'@'y.y.y.y' (using password: YES)

Steps To Reproduce

1. Deploy two mysql servers: 5.6.31 & 5.7.19.
2. Use Sequel-Pro to access it with username and password.
3. Use Sequel-Ace to access it with username and password.

Expected Behaviour

Sequel-Ace can connect to the mysql server with the username and password.

Related Issues

No.

Additional Context

No.

[xgfone]

I cannot understand it. If it is because of mysql server, but Sequel-Pro can connect.

[xgfone]

Moreover, I also have other msyql servers for 5.6.31 & 5.7.19, but both Sequel-Pro and Sequel-Ace can connect to them. I'm going crazy.

[Jason-Morcos]

One thing to check - Sequel Pro uses your .ssh config, but Sequel Ace cannot automatically due to sandboxing. Try selecting your SSH config manually in Sequel Ace's network preferences. Perhaps you have some setting in there that is critical to connecting.

[xgfone]

Thanks for your reply.

I tries to set the ssh config and known hosts, but it is still not ok.

Moreover, I use TCP/IP, not SSH, to connect to the remote mysql server. So, SSH Config should not be used ??

[stale]

This issue has been marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[coolxxy]

I have the same problem.

A mysql server via TCP/IP connect, can connected by Sequel Pro, but can not by Sequel Ace.

[xgfone]

For mysql 5.7, I met with the trouble. For mysql 5.6, however, it's ok.