doubt about making a mysql server
 

Hello:

I am trying to make a sql server, but i wanted that this server can be accesed not just in a normal network but also in internet, for example, the server is in a place and i am in my house and from house i can use the database, how can i make this??

thanks really much
lonrot

All you need to do is install mysql, open the port in you're router if you have one.. Install phpmyadmin and you can access you're mysql by doing http://youip/phpmyadmin .. That worked for me.
Make sure that you give mysql either it's lan IP .. or if it's not in a lan.. the ISP ip.

so it's really symple then :D , but if the server is also in home network, how can i do it so the clients doesn't go the computer just the server??

sorry i know this is the basics but i am newbie :(

thanks
lonrot

by setting a port for mysql/phpmyadmin.. giving the server a static ip .. insert the ip in the phpmyadmin install and mysql ... and setting it in the router, with the port you gave it. That'll make sure that when you do:

http://yourip/phpmyadmin

you go to the server GUI of phpmyadmin and not to your computer and them seeing your files.