Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
4 years ago
Solved

Get data from MySQL tables

Hello Team,

I have connected to mysql db from local host. Server : localhost:3306, db: mysql).

But, after got the data, I am viewing only tables like this (.frm file from mysql folder).

C:/Xampp/mysql files looks like below 

Our folder structure in C drives like this

 

 

But our IT admin told, database stored in  htdocs folder and it is in the format of .sql .

When open that file, it looks like below

 

If I given database name as "htdocs" , but ended with "No such data base message"

 

Can you help me, how to connect this table (.sql type) in my power bi?

which one I need to input in the database space?

 

 

 

Need Help

2 Replies

    • Karthik12's avatar
      Karthik12
      Post Patron
      4 years ago

      amitchandak Hi, Thanks for the reply. Yes, I don't have access to that database. I got access through "privilege" option in the db and now it is working fine for me. 

      But, When ever any data get added in that server, How can referesh my page automatically?

      I seen in the modelling--> change detection is disabled by default.