Connecting Azure Database for MySQL with VS 2022

Question

Connecting Azure Database for MySQL with VS 2022

YouElz 1

I appreciate any help here! I have spent 6 hours trying to configure visual studio community 2022 to connect to Azure Database for MySQL but with no luck!

I do have a Windows Form Application project created.
and when following the below article I don't see similar options.
azure-sql-database-add-connected-service

I have Azure development and Data storage and processing installed...

Thanks

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-18T19:02:12.693+00:00

Hi @YounisElzaharna-0322 Welcome to the Microsoft Q&A Platform, and thanks for your query
Are you trying to connect Azure Database for Mysql or Azure SQL database, as you mentioned Azure database for MySQL and you are referring to Azure SQL.

Regards
Geetha
YouElz 1 Reputation point

2022-07-18T19:06:54.747+00:00

Trying to connect Azure Database for Mysql, but that was the only article I was able to find!

2 answers

Your answer

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-18T19:02:12.693+00:00

Hi @YounisElzaharna-0322 Welcome to the Microsoft Q&A Platform, and thanks for your query
Are you trying to connect Azure Database for Mysql or Azure SQL database, as you mentioned Azure database for MySQL and you are referring to Azure SQL.

Regards
Geetha
YouElz 1 Reputation point

2022-07-18T19:06:54.747+00:00

Trying to connect Azure Database for Mysql, but that was the only article I was able to find!

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

Hi, @YounisElzaharna-0322 Thanks for clarifying that you want to configure the Azure database for Mysql and I agree that we do not have any documentation specific to Mysql.
Can you please follow the steps mentioned here and give it a try.

Please let me know if you are facing any issues.
Also, I would recommend sharing your feedback here to add the documentation for MySQL.

Regards
Geetha

YouElz 1 Reputation point

2022-07-19T05:43:33.13+00:00

Thank you for the below answer. I am sensing from the article that there is no native connection in VS 2022 for Azure Database for Mysql. And i have to install 2 additional connectors! just to be clear.

From where can I install the below connectors?
YouElz 1 Reputation point

2022-07-19T05:44:19.89+00:00

I am also getting this when trying to install Mysql for visual studio 2022
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-19T10:38:25.757+00:00

@YounisElzaharna-0322 you can find the connectors here

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-19T10:41:21.007+00:00

@YounisElzaharna-0322 Yes please install visual studio before Mysql installation.

Regards
Geetha
YouElz 1 Reputation point

2022-07-19T13:34:44.467+00:00

I have visual studio 2022 installed already!

I have mentioned VS2022 in the subject and in my question!!!
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-19T14:42:28.94+00:00

@YounisElzaharna-0322 got it, I have VS2022 and I tried to install MySQL visual studio 2022 and it got installed successfully, I would suggest you to retry again.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-21T03:26:53.67+00:00

@YounisElzaharna-0322 Did you tried uninstalling and reinstalling VS2022?

Regrads
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-22T03:41:04.327+00:00

@YounisElzaharna-0322 The error message is not very helpful to predict the root cause. as I was able to install it from my end, I would recommend you to please file a support ticket for deeper investigation, and in case you don't have a support plan, do let us know here so that we can check on other options.

Regards
Geetha

Answer 2

Luke Murray 11,436 MVP Volunteer Moderator

I haven't tested this personally, but it sounds like you need to Install MySQL for Visual Studio - https://dev.mysql.com/downloads/windows/visualstudio/

Then you can make a connection: https://dev.mysql.com/doc/visual-studio/en/visual-studio-making-a-connection.html

YouElz 1 Reputation point

2022-07-19T05:46:09.01+00:00

I tried installing but it seems is not supported for VS 2022. Image attached above!
Luke Murray 11,436 Reputation points MVP Volunteer Moderator

2022-07-20T19:16:07.47+00:00

There looks to be an open bug with VIsual Studio 2022 support: https://bugs.mysql.com/bug.php?id=105536
You may need to roll back to Visual Studio 2019, until this is resolved.
YouElz 1 Reputation point

2022-07-21T14:58:10.463+00:00

Thank you for pointing this out. The most useful answer so far.

Thanks...

Share via

Connecting Azure Database for MySQL with VS 2022

2 answers

Your answer