Related Documentation Download this Manual Excerpts from this Manual


This page has moved or been replaced. The new page is located here:

Please update any bookmarks that point to the old page.

Download this Manual
User Comments
  Posted by Mark Robbins on January 29, 2008
This may not be a common problem but I have seen it with a JDBC connection.

MySQL is setup on servers A and B. Each server is running a different MySQL database and associated application.

User is logged onto Server A (IP Address XXX.XXX.XXX.3)
User uses Query Browser to connect to Server B (IP Address XXX.XXX.XXX.4).
Connection fails returning message similar to:
Unknown user on server IP Address XXX.XXX.XXX.3

The important item is that the message says that the user tried to login to server A (.3) rather than the intended server B (.4)

The resolution is to:
confirm any firewalls are open
connectivity is possible e.g. via a telnet
execute a grant for the user on server B to allow them to use server A to login.
GRANT ALL ON test.* TO 'userName'@'XXX.XXX.XXX.3' identified by ...
Sign Up Login You must be logged in to post a comment.