Cannot connect to Azure Database for MySQL

0
votes

I created an Azure Database for MySQL. When I try connect to it from MySQL Workbench, it cannot connect. However if I test the connection, the test passes.

When I test the connection, the test is successful:

enter image description here

When I try to connect however, it can't:

enter image description here

On the Azure Portal, I've allowed all IP addresses on the firewall and disabled "Enfore SSL connection":

enter image description here

Any ideas? The connection fails in less than 5 seconds, so I don't think it's a timeout issue. Here is a list of all the timeouts on MySQL Server (on Azure):

enter image description here

1
mysqlazureazure-database-mysql
I'm using MySQL Workbech 8.0.16 and the MySQL Server version on Azure is 5.7 – Fabricio Rodriguez
Try to check if this helps? try increasing timeout value dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html – Nancy Xiong
Thanks Nancy. I can try that, however the error appears within 5 seconds or less of attempting the connection. So it's nowhere near the default of 30 seconds timeout that MySQL Server has? But I will check and let you know. Thanks again – Fabricio Rodriguez
I checked all the timeouts and they seem fine... I've added a screenshot to my original question showing all the timeouts... – Fabricio Rodriguez

1 Answers

0
votes

I resolved the issue by changing the bind_address=0.0.0.0 (mariadb.cnf or mysql.cnf).

Now I can connect to it using telnet (to check the setting).