Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
laxmanqlik
Creator II
Creator II

Error while connecting with MySql

Hello Everyone,

i am trying to connect with the Mysql server with ODBC connector, i am having 2 problems while doing this ...

1. while i am creating an ODBC system DSN with TCP/IP Address as LOCALHOST it showing CONNECTION Success Full,

while i am trying to do the same with TCP/IP Address with my IP ADDRESS it showing "Host <My Domain name> is not allowed to connect to this MySQL "

and the second problem is

2. when i created ODBC System DSN with TCP/IP Address as LOCALHOST and connection got created, then i tried to connect to the MySQL through ODBC connection in QLIK SENSE DESKTOP it showing the error that iam attaching


Here interesting thing is that,The IP Address it showing in error is not my IP Address, its one of LAN machine in my organisation which have Mysql server installed


Please help to sort it out ASAP.



Thanks in advance.



0 Replies