[digital5]

I would like to know how to access the mysql databases on the server from my local computer. i.e. in development of webpages i test on my local server. I also have an mysql server running as well. if I use 'localhost' like i would if the script was running on the server it will try and use my local databases, i want to know what server name to use so it will access the databases on the xilo server.

Hope that makes sense

[XILO]

Originally Posted by digital5

I would like to know how to access the mysql databases on the server from my local computer. i.e. in development of webpages i test on my local server. I also have an mysql server running as well. if I use 'localhost' like i would if the script was running on the server it will try and use my local databases, i want to know what server name to use so it will access the databases on the xilo server.

Hope that makes sense

Hi digital5.

Unfotunately, we do not allow access to MySQL from anywhere apart from the server. This is for security of our customers data.

We understand that this maybe an inconvenience, however, we feel that the security of our customers data must remain paramount.

Thank you

Tom

[computergenius]

SQLYog Enterprise uses HTTP tunneler, which put simply, gives a PHP page which is loaded up to the server. The program itself, a Windows application (.exe) connects to the php page, and on to the database. Is this considered acceptable?

As to the programming issue, I would always use MySQL on my local (windows) computer, for testing and developing. I am not sure why you don't do that. It's quite easy to take a SQL Dump of your online database, and re-create it on your local computer. Plus, if you make any silly mistakes...

[XILO]

Originally Posted by computergenius

SQLYog Enterprise uses HTTP tunneler, which put simply, gives a PHP page which is loaded up to the server. The program itself, a Windows application (.exe) connects to the php page, and on to the database. Is this considered acceptable?

As to the programming issue, you can easily set up (free) MySQL on your local (windows) computer, and this is surely what you should be using.

Yes that would be fine.

I've never heard of that product and sounds really good. Do you have their web address?

Tom

[computergenius]

www.webyog.com

The "online" Enterprise version is $79, and the one without the tunneler - which connects to your development PC, or hosts which allow offsite connection, is free.

I am not sure whether it would be simple (or legal) to use the PHP file which they supply with the trial of the Enterprise version, with other applications.