cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

MySQL Connection (beginner)

Hi all, 

 

I want to create a App for testing something. We have a SQL Database on our Server which contains some Customer Information. 

I Want to connect to the Database to get all this Information and searching for Customers. So ... is it neede to install the Gateway on the Server? Iam a  beginner and dont really know how to do. 

 

Thanks for every help. 

regards nico

5 REPLIES 5
Highlighted
Resolver I
Resolver I

Re: MySQL Connection (beginner)

There is already a Connector for MySQL but you need PowerApps Plan 1 (Premium) for this Connector.

image.png

 

Highlighted
New Member

Re: MySQL Connection (beginner)

Thanks Macwin, 

 

Yes i know ... i have it. The Gateway should i install it on server or where? 

Highlighted
Resolver I
Resolver I

Re: MySQL Connection (beginner)

Highlighted
Super User
Super User

Re: MySQL Connection (beginner)

Hi Nico,

The gateway doesn't need to be installed on the same server where MySQL is installed.

However if you choose to install it on the same server, it can simplify the setup.

The gateway machine needs to able to connect the MySQL server. Most problems occur when this connection fails, often due to firewall or other network settings (port 3306 needs to be open for MySQL). By installing the gateway on the MySQL server, it minimises the possibility of this problem.

Highlighted
New Member

Re: MySQL Connection (beginner)

Hey timl,

 

Thank you for your answer but when i try to connect he want defently a Gateway? How can i use it without? 

I have made a test db on my webosting which is open to access from remote ... there is no way to install gateway

 

mysql_powerapps.png

 

thank you

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

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 (6,907)