cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

MYSQL and Gateway

My question is about Gateways/MYSQL.

 

I have a checkin app for the lobby of an elementary school. Parents late dropping off/pickup early no longer use a sheet of paper, they do it on an app. The app writes checkin/out data to a Sharepoint Online list but Sharepoint has its data limitations. So, I plan to write the data to MYSQL. I connected MYSQL through Powerapps and installed a Gateway but all on my local machine. I realize the Gateway needs to be used on a computer that is always on. I believe we have a server at work that i could use. However, I'm a novice to this so here are my questions:

 

1. Would I need to log in to Powerapps from the server computer, install a new gateway or can i do it remote through my machine?

2. Can i connect everything from the MYSQL database on my machine or would i also need to install MYSQL on the server computer in order to connect data to it from the gateway?

 

Totally confused and I can't find literature online to my specific problem.

 

Guidance is appreciated. Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User II
Dual Super User II

Re: MYSQL and Gateway

Sorry, hit enter too fast.

https://www.youtube.com/watch?v=sx0wCMrlMQc



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User II
Dual Super User II

Re: MYSQL and Gateway

The sound quality isn't great, but here's a YouTube video on how to setup MySQL and PowerApps with a data gateway.  But as I mentioned in my reply to your other post you really don't need MySql.  The MySQL database and gateway are both premium and will add licensing costs to the app.  



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper III
Helper III

Re: MYSQL and Gateway

@Pstork1 I don't see the link to the video. Can you repost it?

Highlighted
Dual Super User II
Dual Super User II

Re: MYSQL and Gateway

Sorry, hit enter too fast.

https://www.youtube.com/watch?v=sx0wCMrlMQc



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,817)