CODEWITHSUNDEEP
c#mysqlwhitelistremote-connection
Alex
Alex

Reputation: 65

Allowing users to remotely connect to mysql db

First of all, I took a look to every related topic on her about this issue. However non of them was successful in answering my question fully.

Curently I am working on a desktop app, coded in C#, that requires mysql connection both for authentication and storing user custom lists etc.

I put my test database in my account on hostgator and I connected to it with a connection string that looks like; 

public static string cs = "Server=xx.xx.xxx.xx;Port=3306;Database=xxx;Uid=xx;Password=xxx";

Even though everything was 100% correct, the connection wasn't possible until I whitelisted my own ip address.

Now everything is working perfect for me, however the thing is that how am I supposed to whitelist all the users of my desktop app for them to be able to connect to the db.

Is there anything that I can do to allow the connection without having to whitelist everyone?

Thank you in advance
Alex

Upvotes: 2

Views: 744

Answers (1)

CodeCaster
CodeCaster

Reputation: 151644

Yes, that'll probably an MySQL (or perhaps even a firewall) configuration option. I guess though that the hoster doesn't allow everyone to connect to a hosted MySQL service, because of the obvious security concerns.

You'd better write a simple service that runs on the webserver, which will publish the data you wish to share. You can then consume this service in your C# app.

Upvotes: 1

Related Questions