MySQL Forums
Forum List  »  Install & Repo

I get this error when trying to connect from a 2nd server "'Host '10.0.0.121' is not allowed to connect to this MySQL server'"
Posted by: Alexander Campos
Date: April 09, 2007 06:00PM

Hi! I'm going to try to explain what is my problem:

I have a MySQL (version 4.1.20) server running on Linux, and on a 2nd server (Win2003) an application that I have to connect to a MySQL database on the 1st server...
Now, when the app tries to connect, I get this error:

'java.sql.SQLException: Data source rejected establishment of connection, message from server: 'Host '10.0.0.121' is not allowed to connect to this MySQL server'

The application uses a web.xml file, where it has this parameter, where you can see, is the Server I'm trying to connect, user and passwd(among other parameters):

<init-param>
<param-name>JDBC_URL</param-name>
<param-value>
jdbc:mysql://10.0.0.100/MyDataBase?autoReconnect=true&amp; zeroDateTimeBehavior=convertToNull&amp;jdbcCompliantTruncation=false&amp; user=MyUser&amp;password=MyPassword
</param-value>
</init-param>

So... I think that on the server running Linux and MySql, I need to give "privileges" to the 2nd server to connect... But How!?

If somebody has seen this before, please!!! can you show me a way to fix this and get the connection to work?

You'll save my.... ;o)
AlexC2

Options: ReplyQuote


Subject
Written By
Posted
I get this error when trying to connect from a 2nd server "'Host '10.0.0.121' is not allowed to connect to this MySQL server'"
April 09, 2007 06:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.