[Database Support] MySQL

[sbehara1]

If you want to see MySQL support in Azure Data Studio, click the thumbs up sign.

Note: Please keep comments to this issue focused on discussions of what you would like to see instead of +1 comments.

[ghost]

Seems support mysql 5.6+ is enough for us.

[ghost]

Would like to see mysql over ssh , mysql tcp/ip, mysql unix socket , these three way connect mysql

[dsghi]

Product name is Azure Data Studio, not MSSQL Data Studio, so I would expect the ability to connect to and manage any database product that is supported on Azure, including MySQL. :)

[m34nbunny]

I am wishing for this everyday, is there a feature branch that has been started for this support yet?

Would love to help contribute

[ghost]

With Azure database for MySQL I would imagine Azure Data Studio should be able to support T-SQL on MySQL. I am starting to look into moving from Google Cloud Platform to Microsoft Azure for WordPress hosting. Using Azure Data Studio and snippets would fit in nicely.

[bonolo]

I would love this functionality. Bog standard 8.0 would be ideal. Even full support of 5.x would make me happy.

[zollo]

I'd appreciate support for MySQL/MariaDB - supported versions only.

[GaboFDC]

Would be nice to get an update on the status of this, just to know if still being considered, if is approved and will be done at some point in the future, just to know what to expect, for know it seems like the support will not come any time soon :(

[vijaychandar1989]

Please give us an update about the support from mysql. I badly require this support.

[499978920]

mysql support
we need
please.

[Leonardo-Ferreira]

Just here to reaffirm that basic query execution agains a MYSQL database would suffice... no auto completion needed or other fancy features...

[jemiller0]

Microsoft's video at https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sql-server-ver15 at 6:48 states that Azure Data Studio supports MySQL. However, while I was able to enable PostgreSQL support using the extension, I don't see an extension for MySQL. Am I missing something?

[firanto]

Since this is a multi platform SQL client, it should at least support MySQL. MySQL 5 is fine. 8 is a plus. The reason is simple. MySQL (and its derivative, MariaDB) still known as a popular choice of relational database. Specially for those who work with unix-like servers. The fact that this tool ran at linux and can't even connect to MySQL, even after mentioned since April last year, is baffling.

[Wauna]

Joining the fray... any update on this?

[btstream]

Any plan or roadmap?

[frugecn]

There's been a couple of demos from Microsoft where I've seen the extension, sure would be nice to see it released.

[maiksandmann]

Any update about the availability of a MySQL connector in Azure Data Studio?

Thx for any feedback.
maik

[naimsulejmani]

There the missing piece of Azure Data Studio is MySQL Connector also some good IntelliSense for that :)

[rafaribe]

Would be superb to have MySQL support.
The only other alternative in MacOS is DataGrip and is slow as hell..

[datauduong]

With Notebook support in Azure Data Studio, it would be very useful to be able to connect to Azure MySQL (Knowing Azure PostgreSQL already been supported in Azure Data Studio)

Azure Data Studio team can you please shed some light on whether this is considered so that we can see the end.

Thanks.

[myusrn]

Its more than a year since this issue was opened. Is support for localhost or azure hosted mysql connection still not supported?

Searched extensions and not seeing any hits.

[rafaribe]

Would appreciate if the devs could just shed some light if they care about such support or not. Just look at the emoji count of the first post. The community cares.

[ramonpego]

i'll have faith

[asharovarov]

Are there any updates on the progress?

[alanrenmsft]

Finally, the support for MySQL in Azure Data Studio is here, it is now available in the ADS Insider's extension gallery:

you can open issues/feature requests at: https://github.com/microsoft/azuredatastudio-mysql, you can also download the visx directly from here.

It should be available in the ADS stable build pretty soon.

[nihirisuto]

NO. F***ING. WAY.

I'm screaming

[vitorgga]

That's perfect. I install in macOS Monterey and all good. I need to install PostgreSQL@14 too because without this don't function.

[myusrn]

@alanrenmsft do you foresee this extension being surfaced in the visual studio code marketplace as well? is there something about surfacing it in azure data studio experience that makes it irrelevant for the vscode experience?

is it considered acceptable to install this this ads insiders extension gallery offering in the current ads non-insiders installation given winget search azuredatastudio currently shows microsoft.azuredatastudio at 1.39.1 and microsoft.azuredatastudio.insiders at an older 1.35.0 release number?

[alanrenmsft]

@myusrn this extension won't be available in vscode, it is based on the connection provider/query provider/dashboard features that are only available in ADS.

For now it only works with ADS version >= 1.40.0, for now, it is the insider build only.

[myusrn]

@alanrenmsft thanks that explains errors i was getting trying to enable in winget published version of insiders build which is 1.35.0 release. i did a check for updates on that and it bumped me to 1.40.0 after which standard issue extensions | mysql | install worked.

is there any ctrl+enter [ execute current statement ] and ctrl+shift+enter [ execute all or current selection ] keyboard shortcuts carry over from the mysql workbench experience, or ads common keyboard shortcut equivalents for these i'm overlooking?

[alanrenmsft]

@myusrn
ADS has the same keyboard shortcuts settings: https://code.visualstudio.com/docs/getstarted/keybindings
and here are the key bindings you mentioned:

if there are selected text, then the selected text will be executed.

[myusrn]

@alanrenmsft that's excellent, thanks.

[yahorsi]

cannot see it, Im on mac and having latest ADS (where can I find the version in ADS?)

[vitorgga]

To install the insiders version go to:
https://github.com/microsoft/azuredatastudio#try-out-the-latest-insiders-build-from-main

Or

In Settings, check Enable Preview Features
https://learn.microsoft.com/pt-br/sql/azure-data-studio/preview-features?source=recommendations&view=sql-server-ver16

[IRCraziestTaxi]

I enabled Preview Features in settings but also do not see the MySQL extension. I guess I need to actually install the Insiders version from build?

[nihirisuto]

I enabled Preview Features in settings but also do not see the MySQL extension. I guess I need to actually install the Insiders version from build?

You need to install the insiders version of Azure Data studio (linked right above your comment), enable preview features, then download the vsix from here: https://github.com/microsoft/azuredatastudio-mysql

Then go into the extensions pane in Azure Data Studio and select install from vsix in this menu:

[IRCraziestTaxi]

So after installing the extension from the extensions tab, it downloaded resources but then did fail to start. I didn't think to get the error before restarting.

Next, I downloaded azuredatastudio-mysql-0.2.1-osx.vsix from https://github.com/Microsoft/azuredatastudio-mysql/releases. After installing, I got this error:

[Error - 2:18:42 PM] Starting client failed
Launching server using command /Users/ircraziesttaxi/.azuredatastudio-insiders/extensions/microsoft.azuredatastudio-mysql-0.2.1/out/ossdbtoolsservice/OSX/v1.6.0-mysql/mysqltoolsservice/ossdbtoolsservice_main failed.

Next I tried azuredatastudio-mysql-0.2.1.vsix, which just did what installing the extension from the extensions tab did (I'm assuming it's the same output as when I did that):

Downloading https://github.com/microsoft/pgtoolsservice/releases/download/v1.6.0-mysql/mysqltoolsservice-osx.tar.gz
(101391 KB)....................Done!
Installing MySQL Tools Service to /Users/ircraziesttaxi/.azuredatastudio-insiders/extensions/microsoft.azuredatastudio-mysql-0.2.1/out/ossdbtoolsservice/OSX/v1.6.0-mysql

Followed by a toast saying "Failed to start MySQL tools service". (Before, that output was followed by an error message, but this time it was just the toast, no error in output.)

After restarting, I see this output:

[Error - 2:26:24 PM] Connection to server got closed. Server will not be restarted.
dyld: Library not loaded: /usr/local/opt/gettext/lib/libintl.8.dylib
  Referenced from: /Users/ircraziesttaxi/.azuredatastudio-insiders/extensions/microsoft.azuredatastudio-mysql-0.2.1/out/ossdbtoolsservice/OSX/v1.6.0-mysql/mysqltoolsservice/ossdbtoolsservice_main
  Reason: image not found

I'm not sure what else I need to install. For what it's worth, I'm on a Macbook with an Apple chip, not Intel. Could that be the issue? Can this extension be run with an M1 chip?

[nihirisuto]

edit: i see you're on windows.

I had this issue on mac and needed to turn the file into an executable that failed to run, I was able to do that from terminal with:

sudo chmod +x /path/to/ossdbtoolsservice_main

not sure what the windows equivalent of that is. This might be of value: https://www.educative.io/answers/what-is-chmod-in-windows

I'm currently having the same libintl.8.dylib issue on an ARM macbook, and have an issue opened here: microsoft/azuredatastudio-mysql#76

[dsghi]

FYI folks asking for help:

you can open issues/feature requests at: https://github.com/microsoft/azuredatastudio-mysql, you can also download the visx directly from here.

[IRCraziestTaxi]

edit: i see you're on windows.

I'm on MacOS Big Sur. I did try your chmod command and it resulted in the same error. It sounds like it might be a chip issue. :/ I guess I'll stay tuned for updates on that.

Thanks for the help, all. Looking forward to being able to ditch DBeaver!

Edit for clarity: The chmod command succeeded, but I got the same error when I restarted ADS.

[ghood97]

@IRCraziestTaxi I had the same issue at first. What I did to fix it was I uninstalled ADS and deleted all of the files (some of the extension files hung around after uninstalling ADS) and then reinstalled and it worked fine. Unfortunately, I don't know where those extension files sit on MacOS but on windows it was in my AppData folder. Hope this helps.

[IRCraziestTaxi]

Well, this has been an adventure.

I found this SO answer about gettext not being found, so I followed the instructions in that answer and installed gettext and re-linked it.

For some reason, homebrew didn't link it to a /usr/local/opt path like I thought it was supposed to... so after some fumbling around (because I don't know what I'm doing - hopefully I didn't set up any problems for myself later by making a bunch of phony links) I managed to get ADS able to see the lib it wanted by doing this:

ln -s /opt/homebrew/Cellar/gettext/0.21/lib /usr/local/opt/gettext/lib

After that, the error is no longer that the lib can't be found, but that it is unusable...

dyld: Library not loaded: /usr/local/opt/gettext/lib/libintl.8.dylib
  Referenced from: /Users/ircraziesttaxi/.azuredatastudio-insiders/extensions/microsoft.azuredatastudio-mysql-0.2.1/out/ossdbtoolsservice/OSX/v1.6.0-mysql/mysqltoolsservice/ossdbtoolsservice_main
  Reason: no suitable image found.  Did find:
	/usr/local/opt/gettext/lib/libintl.8.dylib: mach-o, but wrong architecture
	/usr/local/opt/gettext/lib/libintl.8.dylib: stat() failed with errno=1
	/opt/homebrew/Cellar/gettext/0.21/lib/libintl.8.dylib: mach-o, but wrong architecture
[Error - 3:52:32 PM] Connection to server got closed. Server will not be restarted.

Currently trying to google my way around that error, although I'm not optimistic given that it's an arch mismatch issue.

Edit: I see this is a similar issue to the issue linked above by @chris-larsen. I'll keep an eye on that issue as well.

[yahorsi]

This is on Macbook Pro m1

[nrogachev]

@yahorsi try installing PostgreSQL@14 (brew install PostgreSQL@14)

[yahorsi]

@nrogachev why? I need it for mysql

[nrogachev]

@yahorsi the guy above posted and it also helped me to get it running. I'm on Intel chip though,

[rishky-msft]

Hi @nrogachev @yahorsi @IRCraziestTaxi @ghood97 @dsghi @vitorgga

Can you try out this VSIX in latest Azure Data Studio insider and check if this resolves the issues on MAC. (Both intel and arm based)
https://github.com/microsoft/azuredatastudio-mysql/releases/download/v0.2.2-alpha.1/azuredatastudio-mysql-0.2.2-alpha-1.vsix

This does not have dependency on installing postgresql@14.
It should work without postgresql installation also.

[IRCraziestTaxi]

@rishky-msft It works! Thanks so much! I'm so glad to finally be able to ditch DBeaver!

[alanrenmsft]

for those on Apple Silicon, please try out the new Azure Data Studio Insiders build for Apple Silicon, details can be found here: #16125 (comment)

@yahorsi

[alanrenmsft]

the extension is available for latest stable build now.

[jroosameresco]

the extension is available for latest stable build now.

YES! I can finally use ADS as my all-in-one UI for managing all my dbs (MSSQL, MYSQL, and POSTGRES). Thank to everyone responsible for making this a reality. I just tried it and everything seems to be working well. Now if only we had integrated ssh tunneling (haha - no complaints, this is a good day!)

[myusrn]

Any updates on whether or not this ads vsix extension for mysql support can be used in vscode ide as well?

[alanrenmsft]

@myusrn the MySQL extension only works with ADS.