I created a file for each division of the company and would like the division administrative assistant to be able to refresh Mysql queries in the file. When they open the Excel 2010 file and try to refresh they get the attached message.
I want to allow other users to be able to refresh the Mysql connections without giving them access to the database. Is this possible and what settings need to be in place?
Any help would be appreciated.
Hi Carolyn,
The MySQL Connector is no installed, follow the link provided in that error message to download and install the missing connector.
However, without credentials, users will not be able to refresh the data. Depending on your queries, you might be able to add a user account to your MySQL database, with access privileges: you can give to a user database-level privileges, or just table-level privileges, or even table columns privileges.
See this article for more details: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/grant-tables.html
You have to clarify what users can access and make sure users have access to that table you want them to refresh. They will not be able to refresh tables without user privileges.
You can try Power BI, they will be able to update the reports, in fact, you will setup a scheduled refresh, they will always have latest data without having to refresh manually.
Hi Catalin,
Thank you for your response. It confirmed what I thought was required for MySQL connections.
I will try Power BI.
Have a good day!
