is there a functionality to connect application to mysql thro http.
for eg. i could have mysql running at port 80 and another app that
connects to the mysql db using http calls.

Seede

Junkone wrote:
> is there a functionality to connect application to mysql thro http.
> for eg. i could have mysql running at port 80 and another app that
> connects to the mysql db using http calls.
>
> Seede

No.

Why would even consider something like this... The security risks would
be astronomical. You also seem to be confusing protocols with ports
numbers. Mysql server can only receive information from a mysql client
- and that client must be able to authenticate, present a query and
receive the result in a very particular format. Configuring it on port
80 does NOT allow you to communicate using the http protocol. You need
to learn the differences between port numbers, protocols and languages.

Port 80 is the standard port for the http protocol, just as port 22 is
the default ssh port and port 25 is the default smtp protocol(mail)
port. The MySQL server requires a client that can speak it's
"protocol". It cannot speak http protocol.

On Apr 2, 11:19pm, Michael Austin <maus...@firstdbasource.com> wrote:
> Junkone wrote:
> > is there a functionality to connect application to mysql thro http.
> > for eg. i could have mysql running at port 80 and another app that
> > connects to the mysql db using http calls.
>
> > Seede
>
> No.
>
> Why would even consider something like this... The security risks would
> be astronomical. You also seem to be confusing protocols with ports
> numbers. Mysql server can only receive information from a mysql client
> - and that client must be able to authenticate, present a query and
> receive the result in a very particular format. Configuring it on port
> 80 does NOT allow you to communicate using the http protocol. You need
> to learn the differences between port numbers, protocols and languages.
>
> Port 80 is the standard port for the http protocol, just as port 22 is
> the default ssh port and port 25 is the default smtp protocol(mail)
> port. The MySQL server requires a client that can speak it's
> "protocol". It cannot speak http protocol.

i appreciate your concern. maybe i should have explained it better. I
was looking to expose the mysql data thro a webservice or something
similar. any products that are opensource that provide such features.
i was looking to connect from my app to connect to mysql thro a
webservice connector to query data

"Junkone" <junkone1@gmail.com> wrote in message
news:6feda986-c2d7-408d-a659-34cbc8454beb@x41g2000hsb.googlegroups.com...
> is there a functionality to connect application to mysql thro http.
> for eg. i could have mysql running at port 80 and another app that
> connects to the mysql db using http calls.
>
> Seede

Yes,
check mySQLyog, it has a php script exactly for that. Maybe you can
use it take it as an example?

Richard.