Allowing remote hosts to connect

[kiwis]

I know this is not a good idea but I only want one of my databases to allow this and then a script on my server will get all "good" records and add the "main" secure database.

My question is using PHP MyAdmin how do I set the Privileges to allow remote hosts to add/edit and delete records??

[penagate]

That would be a question for your web host. Unless your web host is you, in which case you need to forward the MySQL port (3306 by default) and make sure it's not blocked by any firewall. This will allow incoming connections. Then, for security reasons, you should add an account for remote access, and give it only as many priveleges as it needs. I don't know off hand if you can manage accounts in phpMyAdmin but you can do so using the GRANT command.

Or, alternatively, you could build your own Web API to encapsulate the tasks needed. If you're not comfortable with using SQL then this is probably the easier option. However it does require you to be comfortable with PHP based authentication (using sessions). Otherwise, you can easily make it just as much of a security risk.

[visualAd]

Your web host won't open up the mysql port. Your best bet is to find a web host which gives you an SSH loing and use a tunnel for the mysql port.