connection to mysql via remote host

[NZ_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??

[mjax]

The safe way would be to add a specific user for this remote host and specify it's IP address in the host field of the user table. That way only from that specific IP address a connection can be established to your MySQL server.

[NZ_Kiwis]

This what I have and the error i get...

Change Login Information / Copy User

User name: Use text field: (rlnz)
Host: Use text field: (%)
Password: Do not change the password

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'rlnz'@myip.xtra.net.nz' (using password: YES) in C:\Program Files\xampp\htdocs\zz.php on line 4

Could not connect: Access denied for user 'rlnz'@myip.xtra.net.nz' (using password: YES)

<?php
$link = mysql_connect('207.*****.27', 'rlnz', '**');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>