Hi,

I am on the machine 192.168.0 230, and I am trying to connect to the server
on 192.168.0.10.

>mysql -h 192.168.0.10 -u username -p

I get back

>ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111)

OK, so I tried to connect to the local server

>mysql -h 192.168.0.230 -u username -p

And I get back

>ERROR 1130: Host '192.168.0.232' is not allowed to connect to this MySQL
server

I can connect on localhost though

>mysql -h localhost -u username -p

I read the MySQL manual on the subject, and if I do

>mysqladmin -h `hostname` version -u username -p

I get
Server version          3.23.49
Protocol version        10
Connection              thor.sbs via TCP/IP
TCP port                3306
Uptime:                 8 days 23 min 22 sec

thor.sbs is the local machine at 192.168.0.232. But if I try to use the IP
>mysqladmin -h '192.168.0.232' version -u username -p
I get
mysqladmin: connect to server at '192.168.0.232' failed
error: 'Host '192.168.0.232' is not allowed to connect to this MySQL server'

I know I am not understanding something fundamental here. Any help would be
appreciated, pointers to articles, etc.

Thanks very much,
Rich


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to