The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Connectin Excel with MariaDB

Hello ! A Question from a begginer.

I have been trying to connect Excel 2007 with MariaDB. 1) I downloaded the latest ODBC connector. 2) I created in Windows a new ODBC connection fron the control panel 3) From excel I created selected the connection and

I can only see the TEST and PERFORMANCE_SCHEMA Databases. I don´t see any of my DataTables.

What could be happening?

Answer Answered by Rhys Campbell in this comment.

Did you set a username and password in the ODBC connection?

I'm guessing not. You've probably logged in with an anonymous user that only has access to the mentioned database.

You need to change your connection to use a user that has access to your other databases. You should also secure your installation if I'm correct. Here is a good start https://mariadb.com/kb/en/mariadb/mysql_secure_installation/

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.