[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?

[firanto]

No response from devs for don't know how long... 😶

[stefanreimers]

We asked about that on Twitter but until now we only got a vague answer from the PM https://twitter.com/OneBitAhead/status/1307954947036717056

[myusrn]

Fyi, as an interim alternative i'm using azure data studio supported jupyter notebook with python kernel and the standard issue mysql pypi package. An overview can be found in this 10min walkthrough video and summarized in the following.

1. install azure data studio
2. azure data studio | file | new notebook
3. <notebook>.ipynb | manage packages | add new | mysql and mysql-connector
4. set db_host=<your_db_host>& set db_user=<your_db_user>& set db_pswd=<your_db_pswd>& set db_name=<your_db_name> . . . and for linux distro leave out set or swap with export for enabling across all processes
5. use following code in notebook code cell or spread across many cells if you want to intermix with markdown information

import mysql.connector as mysql; 
db_host = os.environ.get('db_host'); db_user = os.environ.get('db_user'); db_pswd = os.environ.get('db_pswd'); db_name = os.environ.get('db_name')
db_conn = mysql.connect(host=db_host, user=db_user, passwd=db_pswd, database=db_name, use_pure = True)
db_conn # or print(db_conn)

db_tables = pd.read_sql_query('show tables from ' + db_name, db_conn)
db_tables # or print(db_tables)

tables = db_tables['Tables_in_' + db_name]
tables # or print(tables)
for table_name in tables: 
	output = pd.read_sql_query('describe {}'.format(table_name), db_conn)
	print('describe ' + table_name)
	print(output, '\n')

Should be clear that the python pandas package call pd.read_sql_query('<mysql statements>', db_conn) is how you execute mysql commands and view output in notebook. For some use cases this azure data studio notebook approach may be preferred given you get the benefits of being able to insert nice markdown in between statements and have output for a given run captured in a nicely formatted way for sharing.

[noahbroyles]

Yeah Microsoft what the heck mon? Where is support for the most common free RDBMS?

[tinwinaung]

I believe most want to use MariaDB ... please thumb up on MariaDB request here https://github.com/Microsoft/azuredatastudio/issues/4917

[nmklotas]

There's no good mysql/mariadb IDE, so support for mysql/mariadb in Azure Data Studio would be much appreciated!