I have created a database in MySQL called 'Sales Data' at server 127.0.0.1. I log into this database on MySQL workbench as user root with my password, and everything works fine.
On Power BI, I am trying to connect by doing Get Data -> MySQL Database -> Server: 127.0.0.1, Database: Sales Data -> user: root and my password (the same one that is working for MySQL Workbench. I am getting an error that says it can't find my Sales Data db. I have also tried connecting through localhost as the server. Still doesn't work.
I installed MySQL with the oracle installer, which automatically installed all the necessary connectors, etc. Any idea why it can't find my database?
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
