Helpful Information

Category: C#

C# -> MySQL via port80.

Hi!

I have made a C# application which need to communicate with a MySQL server. This application will be used in several different restricted networks and will be communicating with a MySQL server (windowsbased).

Since I dont really know which ports are going to be open (depending on the network the application is in) I need to send the sql commands via port 80. They also have to be encrypted.

I have full admin rights of the SQL server.

Does anyone have any ideas how this would be done in the smartest way? The MySQL server is Windows based.

Thank you!

Well first the MySQL server has to be configured to listen on port 80. However a word of warning, that means you cannot also host a website on port 80 on the same machine. Or at least the same IP address on the same machine.

Are you using the MySQL connector objects in C# to connect to the MySQL server?

Well first the MySQL server has to be configured to listen on port 80. However a word of warning, that means you cannot also host a website on port 80 on the same machine. Or at least the same IP address on the same machine.

Are you using the MySQL connector objects in C# to connect to the MySQL server?

Yes I am. But isnt there a way to use webservices? Im not really good at this. Lets say I send a SQL command over port 80 encapusalted in an http header (dont know how this should be done) isnt there a way to have an application on the server side to determine if its a SQL command or just regular HTTP?

Yes I am. But isnt there a way to use webservices? Im not really good at this. Lets say I send a SQL command over port 80 encapusalted in an http header (dont know how this should be done) isnt there a way to have an application on the server side to determine if its a SQL command or just regular HTTP?

Theoretically it is possible but it would be very complicated. Trying to determine if the request is an SQL request versus a normal web request. I would advise against doing this. It isn't possible to open a different port? Or run the website on a different port than 80?