|
Any mysql connection from any place has to be accepted by both parties and yeah any php can access it if its allowed.
Goto your Website retrieve the IP address all domains are linked to a IP.
GRANT ALL PRIVILEGES ON *.* TO 'USER'@'IP-HERE' IDENTIFIED BY 'PASS';
Inject this into your navicat or w/e your using if navicat select db and press f6. and then past that with correct info to allow your website to access your mysql db. then use the same user and pass you just created with that command. for example heres a good way to do it....
$connection = mysql_connect("VPS?IP", "USER", "PASS");
$db = mysql_select_db("zf", $connection);
Then your website can access your VPS or DEDI or where ever your mysql database is located just remember. That any outside site accessing a mysql database is and always will be slightly slower on retrieving information. Local is instant this account will prob be banned like my other one but your welcome in advance.
|
