4

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

Improve this question
6
  • 2
    Have you mixed up MySQL with SQL Server? 1433 is the port on which SQL Server listens. MySQL uses a different port. And there is no "Azure MySQL" product. Azure SQL is a SQL Server database. In any case, It doesn't matter which port you open on your machine, it's the server's port you want to connect to. For Azure SQL there are tutorials that show you how to connect securely. Commented Jun 13, 2016 at 15:55
  • Microsoft has kind of embraced open source and apparently offers MySQL databases in Azure. Of course, MySQL default port is 3306 and I can't tell whether they allow remote access. Commented Jun 13, 2016 at 16:42
  • Please edit your question to show how you configured your connection in MySQL Workbench (of course, please don't include your real server name, username, or password). Note: All needed information for connecting is provided within the Settings->Properties blade for ClearDB-based MySQL databases (where you'll need hostname, port, username, and password). Commented Jun 13, 2016 at 20:31
  • @DavidMakogon Done, I have added my settings. Commented Jun 14, 2016 at 0:50
  • 1
    @Dliix - that's because your database isn't MySQL - it's SQL Database. See my answer. Commented Jun 14, 2016 at 1:00

1 Answer 1

Reset to default
7

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Alright, I got it thanks ! Do you have any software that I could use to manage my DB other than Visual Studio then ? Because VS is actually very slow... Thanks again !
A quick google search of "SQL Server Management Tools" will enlighten you :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.