Get data from MySQL tables

[Karthik12]

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?

[amitchandak · Accepted solution]

@Karthik12 , Does the current user you are using in power bi have access to that database ?

[Karthik12]

@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.