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/