Bug #105397 Connection to Azure MySQL Db hangs forever
Submitted: 1 Nov 2021 13:02 Modified: 2 Nov 2021 8:08
Reporter: Andrei Korostelev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version: OS:Ubuntu
Assigned to: CPU Architecture:Any

[1 Nov 2021 13:02] Andrei Korostelev
Description:

The command below hangs forever trying to connect to the Azure MySQL Db
$ /mysql -h <host> -u <user> <db>
The same goes for MySQL C API (mysql_real_connect() blocks forever)

Downgrading mysql-client v.8.0.26 made the problem disappear.

Extra info

$ mysql -V
mysql  Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:        20.04
Codename:       focal

How to repeat:
$ mysql -V
mysql  Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Connect to the remote Azure Db (with SSL enabled)
$ /mysql -h <host> -u <user> <db>
[2 Nov 2021 8:08] MySQL Verification Team
Hello Andrei Korostelev,

Thank you for the bug report.
Imho this is duplicate of Bug #105288, please see Bug #105288.

Regards,
Ashwini Patil