cancel
Showing results for 
Search instead for 
Did you mean: 

MII 12.2 + problem connecting to MYSQL database

0 Kudos

Hi,

We are working with MII 12.2

We are trying to connect to MYSQL server.

I have uploaded and also deployed the MySQL JDBC driver using the JDBC driver link under System resources.

We have created connection using the IDBC connector and below are the configuration details

1.     jdbc:mysql://<<Server IP>>/<<DBName>>

2.     Driver class- com.mysql.jdbc.Driver

Below is the log message

Unable to get a connection from the pool
[EXCEPTION]
java.sql.SQLException: null,  message from server: "Host 'WS-165001790' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError....

Can anyone please guide me on why this error is coming?

Do I need to open port for MII to connect to this MySQL server?

Thanks

Vishal Jadhav

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Vishal,

I am using una2000.jar driver for connecting to MySQL Server with following details:

JDBC Driver: com.inet.tds.TdsDriver

url: jdbc:inetdae:<server>:<port>?database=<db_instance>&sql7=true

and it is working fine.

What is the driver you are using?

Have a look at the following link on the MySQL Developer Zone which describes the same problem and the solutions:

MySQL :: Host 'MachineName' is not allowed to connect to this MySql Server

For opening the port for MySQL server, check this link which describes the way to open the port manually:

MySQL :: How do I maually open port 3306?

Regards,

Rohit Negi.

0 Kudos

com.inet.tds.TdsDriver - JDBC driver is used to connect to SQL server.

I am using - com.mysql.jdbc.Driver.

Former Member
0 Kudos

Hi Vishal, You can check this Bloggity Blog Blog Blog: &amp;#8220;Host is not allowed to connect to this mysql server&amp;#8221;

This blog speaks about the host/user not having privileges to access the database