Hi all!
I have asked this before, but no replys. I'll rewrite the question
because I don't know if I got understood. ;-) Anyway, I have not found a
MySQL list best suited for this question, so here I go...
¿Anyone knows why the server (mysqld) behaves differently to clients
connecting from the same remote machine?
(Server 3.23.41 on a RedHat 7.2. The client is Windows XP Professional.)
In other words, say we are connecting from Host B to Server A. Well, I
will list the possible responses I'm getting (remember, always speaking of
low level socket connections).
- telnet servera 3306 --> Response OK. (First handshake
packet received OK).
- MySQLFront --> Response OK. (MySQLFront connects
OK).
- mysql -u user -h servera --> Response OK. (MySQL client connects
OK).
- nc servera 3306 --> Response OK. (First handshake
packet received OK).
OK, at this point, you do think all is ok, don't you? not quite...
- Connecting via a simple TCP socket coded in Borland C++ Builder
5.0:
The first packet response is: "1130: Host 'hostb' isn't allowed
to connect to this mysql server."
I am not even allowed to reply with the packet that identifies my
to the server.
Pardon? What?? "I'm not ALLOWED to connect to the server?
As you can see, this is nonsense because I CAN connect to the server as
seen above. I have not come to a conclusion on this topic, so all you can
help is greatly appreciated.
I go so far as to capture the packets with a packet sniffer (ethereal),
and I got crazy: Everything seems fine, all connections generate the same
packets, in the same order... But when connecting from my program, I get
that 1130 error.
Cheers,
Jose Miguel.
PS: Yes, I have done a "mysqladmin flush-hosts" everytime.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
