Afficher un message
Vieux 19/09/2007, 22h50   #5
Good Man
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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)



  Réponse avec citation
 
Page generated in 0,06672 seconds with 9 queries