ODBC connection issue (from MySQL database)

[ucatchy]

Hi guys,

I've built a pretty basic database using MySQL Workbench - and I've uploaded a bunch of data. Now I am trying to pull data from my database into MS Excel using an ODBC connection via Excel's Get Data. However, after setting up the ODBC connection, I'm getting the following error for ALL my data fields/columns:

DataSource.Error: ODBC: ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.26]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.columns_priv' at line 8 Details: DataSourceKind=Odbc DataSourcePath=dsn=MySQL Local OdbcErrors=

I've searched all over for ideas - I've even tried adding text: SET sql_mode='ANSI_QUOTES' into the Initial Statement field in the Details option in the ODBC connector, as I thought it could be quotes related?

My versions: MySQL Workbench 8.0.26, MySQL Connector/ODBC 8.0.26, MS Excel 2019

Can anyone see where I'm going wrong, or how I can fix this?

Any help would be most appreciated. Thanks,

Stevie