Posted by Etienne Marais on 12/04/05 05:37

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]