how to access a mysql database online from a local website?

Question

I'm trying to connect to a database online from a local website, but I got the first error 'connessione fallita'. It isn't a problem of configuration because if I try to use the same code online (it is an inc file) it works! How can i fix it?

<?php $connessione=@mysql_connect('ip','username','password');
if (!$connessione){
        echo('connessione fallita');
        exit();
    }
if (!@mysql_select_db('nameofthetable')){
        exit('la selezione database non ha funzionato');
    }
?>

Obviously I changed the values of 'ip', 'username', 'password', and table here for security reasons.

If you have a problem, then don't **suppress** errors! Get rid of those `@`s! — Quentin, Oct 09 '13 at 08:17
You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, Oct 09 '13 at 08:18

score 0 · Answer 1 · answered Oct 09 '13 at 08:24

0

Troubleshoot. Try to connect from command line or with a client. Check error returned(not php error message). most likely it is due to the user not having access from your IP.

answered Oct 09 '13 at 08:24

AdrianBR

2,762
1
15
29

how to access a mysql database online from a local website?

1 Answers1