on 01-08-2014 12:43 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vishal, You can check this Bloggity Blog Blog Blog: &#8220;Host is not allowed to connect to this mysql server&#8221;
This blog speaks about the host/user not having privileges to access the database
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.