Connecting to database (phpmyadmin) hosted on website from SQL management studio and/or Power BI
Been searching for a few days now so any assistance with be highly appreciated...
I have a website that has a few forms which collects information from users visiting the site. This information is then written to a database (phpMyadmin) on the site.
I want to use Power Bi and connect to the database to perform some analytics. I have been unsuccessful thus far and ready to hand in the towel.
Steps taken thus far:
- created a user that can access the database
- ensured remote access for my machine via Remote MySQL
- downloaded and installed mySQL Connector
mysql sql web powerbi
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
add a comment |
Been searching for a few days now so any assistance with be highly appreciated...
I have a website that has a few forms which collects information from users visiting the site. This information is then written to a database (phpMyadmin) on the site.
I want to use Power Bi and connect to the database to perform some analytics. I have been unsuccessful thus far and ready to hand in the towel.
Steps taken thus far:
- created a user that can access the database
- ensured remote access for my machine via Remote MySQL
- downloaded and installed mySQL Connector
mysql sql web powerbi
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
1
Welcome to Stack Overflow! What does "I have been unsuccessful" means? What happens? Do you get an error? Do you see login dialog when you click Connect in Get data from MySQL? Does your connector match the architecture of Power BI Desktop (32 vs 64 bit)?
– Andrey Nikolov
Nov 11 '18 at 18:47
was getting an unable to connect error. figured the issue though...remote sql required my public ip instead of local ip
– PoolHall Junkie
Nov 15 '18 at 7:31
add a comment |
Been searching for a few days now so any assistance with be highly appreciated...
I have a website that has a few forms which collects information from users visiting the site. This information is then written to a database (phpMyadmin) on the site.
I want to use Power Bi and connect to the database to perform some analytics. I have been unsuccessful thus far and ready to hand in the towel.
Steps taken thus far:
- created a user that can access the database
- ensured remote access for my machine via Remote MySQL
- downloaded and installed mySQL Connector
mysql sql web powerbi
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
Been searching for a few days now so any assistance with be highly appreciated...
I have a website that has a few forms which collects information from users visiting the site. This information is then written to a database (phpMyadmin) on the site.
I want to use Power Bi and connect to the database to perform some analytics. I have been unsuccessful thus far and ready to hand in the towel.
Steps taken thus far:
- created a user that can access the database
- ensured remote access for my machine via Remote MySQL
- downloaded and installed mySQL Connector
mysql sql web powerbi
mysql sql web powerbi
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
edited Nov 12 '18 at 2:38
Isaac Bennetch
7,73121629
7,73121629
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
asked Nov 11 '18 at 14:27
PoolHall Junkie
12
12
1
Welcome to Stack Overflow! What does "I have been unsuccessful" means? What happens? Do you get an error? Do you see login dialog when you click Connect in Get data from MySQL? Does your connector match the architecture of Power BI Desktop (32 vs 64 bit)?
– Andrey Nikolov
Nov 11 '18 at 18:47
was getting an unable to connect error. figured the issue though...remote sql required my public ip instead of local ip
– PoolHall Junkie
Nov 15 '18 at 7:31
add a comment |
1
Welcome to Stack Overflow! What does "I have been unsuccessful" means? What happens? Do you get an error? Do you see login dialog when you click Connect in Get data from MySQL? Does your connector match the architecture of Power BI Desktop (32 vs 64 bit)?
– Andrey Nikolov
Nov 11 '18 at 18:47
was getting an unable to connect error. figured the issue though...remote sql required my public ip instead of local ip
– PoolHall Junkie
Nov 15 '18 at 7:31
1
1
Welcome to Stack Overflow! What does "I have been unsuccessful" means? What happens? Do you get an error? Do you see login dialog when you click Connect in Get data from MySQL? Does your connector match the architecture of Power BI Desktop (32 vs 64 bit)?
– Andrey Nikolov
Nov 11 '18 at 18:47
Welcome to Stack Overflow! What does "I have been unsuccessful" means? What happens? Do you get an error? Do you see login dialog when you click Connect in Get data from MySQL? Does your connector match the architecture of Power BI Desktop (32 vs 64 bit)?
– Andrey Nikolov
Nov 11 '18 at 18:47
was getting an unable to connect error. figured the issue though...remote sql required my public ip instead of local ip
– PoolHall Junkie
Nov 15 '18 at 7:31
was getting an unable to connect error. figured the issue though...remote sql required my public ip instead of local ip
– PoolHall Junkie
Nov 15 '18 at 7:31
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53249679%2fconnecting-to-database-phpmyadmin-hosted-on-website-from-sql-management-studio%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53249679%2fconnecting-to-database-phpmyadmin-hosted-on-website-from-sql-management-studio%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Welcome to Stack Overflow! What does "I have been unsuccessful" means? What happens? Do you get an error? Do you see login dialog when you click Connect in Get data from MySQL? Does your connector match the architecture of Power BI Desktop (32 vs 64 bit)?
– Andrey Nikolov
Nov 11 '18 at 18:47
was getting an unable to connect error. figured the issue though...remote sql required my public ip instead of local ip
– PoolHall Junkie
Nov 15 '18 at 7:31