Posted by chris on 12/04/05 13:54

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
>

[Back to original message]