Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Connect to Azure MySQL Database using MySQL Workbench

I have a Web App running on Azure. I can connect to the DB with Visual Studio and sending/retrieving data on my app works fine.

However, I can not connect to the MySQL db using MySQL Workbench. The error that I have is

Lost connection to MySQL server at 'reading initial communication packet', system error: 54

I have whitelisted my IP on the azure portal and opened the port 1433 on my computer. I don't understand why can't I connect using MySQL Workbench while having no problem with Visual Studio.

EDIT:

Here is how i have setup MySQL Workbench:

MySQL Workbench

And Here is my Azure portal:

Azure Portal

I'm using port 1433 because that is the port given on the Azure Portal, but also in this tutorial: Connect to Azure DB using MySQL Workbench

like image 861
Dliix Avatar asked Oct 13 '25 02:10

Dliix


1 Answers

Ok - now that you included screenshots: You're trying to use MySQL Workbench to connect to a SQL Database (which is SQL Server as a service, not MySQL).

Edit: 8/15/2017 Azure now offers Azure Database for MySQL which is currently in public preview.

In your specific case, you created a SQL Database, which cannot be manipulated with MySQL Workbench.

like image 126
David Makogon Avatar answered Oct 14 '25 18:10

David Makogon