CODEWITHSUNDEEP
mysqlazuremysql-workbench
Dliix
Dliix

Reputation: 716

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

Upvotes: 4

Views: 10127

Answers (1)

David Makogon
David Makogon

Reputation: 71030

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.

Upvotes: 7

Related Questions