how to connect to a remote computer?

Hi,

I can connect to the local computer like:
objdc.Open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306;
Option=0; Socket=; Stmt=;"_
& " Database=mydb; Uid=root; Pwd=mypw;"

but what's the syntax to connect to a remote computer (e.g. 10.0.0.180)?

Thanks
Chris

Set Server=10.0.0.180

Thanks, but then , i get this error:
"server 'mycomputer' is not allowed to connect to mysql" (or something like
this)

It runs like a service in windows. How can i allow it?
Thanks again

"Sean" <oreilly.sean@gmail.com> schreef in bericht
news:1133545209.074428.305300@g44g2000cwa.googlegr oups.com...
> Set Server=10.0.0.180
>

chris wrote:

> Thanks, but then , i get this error:
> "server 'mycomputer' is not allowed to connect to mysql" (or something
> like this)
>
> It runs like a service in windows. How can i allow it?
> Thanks again

Try connecting to the remote MySQL
server using the MySQL client,

e.g. c:\my_mysql_path\bin\mysql -u root -p -h 10.0.0.180

(you enter your password after hitting the return key)

I suspect it is simply a matter of
user root in MySQL being allowed to
connect from localhost using password 'mypw'

but not from other hosts,
remember that access is restricted
by host+username and that you can
even have different passwords for
the same username, but different hosts.

What app. are you using to administrate
your MySQL database ?

--
Etienne Marais
Cosmic Link
South Africa

This works: c:\my_mysql_path\bin\mysql -u root -p -h 10.0.0.180.

I use Mysql administrator 1.1.5 , but where can i set it so i can connect
from a host in
objdc.Open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306;
Option=0; Socket=; Stmt=; Database=mydb; Uid=root; Pwd=xxx"

Thanks
Chris







"Etienne Marais" <etienne@cosmiclink.co.za> schreef in bericht
news:dmto79$ag2$1@ctb-nnrp2.saix.net...
> chris wrote:
>
>> Thanks, but then , i get this error:
>> "server 'mycomputer' is not allowed to connect to mysql" (or something
>> like this)
>>
>> It runs like a service in windows. How can i allow it?
>> Thanks again
>
> Try connecting to the remote MySQL
> server using the MySQL client,
>
> e.g. c:\my_mysql_path\bin\mysql -u root -p -h 10.0.0.180
>
> (you enter your password after hitting the return key)
>
> I suspect it is simply a matter of
> user root in MySQL being allowed to
> connect from localhost using password 'mypw'
>
> but not from other hosts,
> remember that access is restricted
> by host+username and that you can
> even have different passwords for
> the same username, but different hosts.
>
> What app. are you using to administrate
> your MySQL database ?
>
> --
> Etienne Marais
> Cosmic Link
> South Africa
>