Re: Setting UP MySQL for Online Connection

[John Peter Paredes]

Peter Brawley Wrote:
-------------------------------------------------------
> MySQL version?
>
> MySQL server and SqlYog are on one machine, or are
> there other LAN machines from which you wish to
> connect?
>
> Making your local MySQL installation
> internet-visible is a different matter. It opens
> you to massive cyber risks. If you really want
> such a world-visible in your home, you need a few
> semesters of kowledge about web servers, database
> administration &c.
>
> Which is why for most people the preferred
> direction is to buy shared internet hosting that
> supports MySQL. Then you'll use your local machine
> to develop & test databases & apps, and the web
> hosting to serve the to the world.


Hello and thank you for your reply.

I only have 1 Computer with internet connection. the ISP provided us with a STATIC IP. i wanted to test this so that i can create Visual Foxpro Applications that can access a centralized database online. currently, all my applications are offline use only, can be accessed through a local network. i am thinking of maybe using VPN if that can be done ? it maybe more secure than a LIVE mysql. but i don't know what are the requirements. Server Hosting websites kind of limit me with how i can easily access and manage my database. i had to use their tools, also i have only tried the Timed versions of those for testing and i have not used a proper one before.