Re: Accessing Database on another PC
Good Man <heyho@letsgo.com> wrote in
news:Xns99B0B54044F57sonicyouth@216.196.97.131:
>> Errr ok - but what's the syntax ??? do I literally just use the ip
>> for the host with the localhost password ??
>>
>>
>
> yeah, its the same syntax:
>
> @ $db = mysql_connect("the.ip.address.here", "yourUserName",
> "yourPassword");
>
> you will need to make sure that the user has permission to connect to
> the database from a computer that is not 'localhost'.... this can be
> done by setting the "Host" column in the table "mysql" to "%" for your
> particular user...
i was assuming PHP usage there, by the way. if you just want to use
command line, just telnet/SSH to the other computer first and do it from
there (mysql -u USERNAME -p)
|