Exposing your mysql database through a web server

[dzisaacs]

Is there a way of exposing your database through a web server so that you can access it with a URL. Can you do that with MySQL?

 

[TonyGroves]

You don't need a web server to access a MySQL database; just open port 3306 (or whatever port you use) to the world (after making sure you have the permissions right!). You can then use any MySQL client program to access it, specifying the host address at connection time.

 

[dzisaacs]

could you give me an example of a link using that port...

i need to have a link because i want to insert some data using xslt to a mysql database, and it looks like the document() function will help me having the url inside

my database name is daniel

for example
document(

http://localhost/daniel/)

i need to have something like this in order to store or retrieve things from the database

 

[TonyGroves]

I don't know of any direct way to access a MySQL database using http, but one possibility might be to write a little CGI program that will take SQL code as a URL argument, and process it, returning data if required. For example, something like:
[tt]

http://localhost/mysql.cgi?sql=INSERT daniel.tbl (id,text) VALUES (123,'abc')

[/tt]