Error while connecting to MySQLenterprise Edition

[rajendra1918]

Dear Friends,i am trying to connect to my sql enterprise edition with credentials

Getting below error.

please help me.

Error Message:Please check the values for username,password,hostname and other properties. General error is discription.

Regards,

Rajendra

[JustinDallas]

That's a very overly broad and useless error.  But you would have to troubleshoot, here is what I would try in no particular order.

1 .Can you connect to the server with MySQL Workbench using your credentials?

2. Can you ping the server?

3. Is the MySQL service running?

[rajendra1918]

Hi

I have tested and able to connect to MySQL.i am trying to trouble shoot at server itself.

Thanks for prompt response.

Regards,

Rajendra

[balabhaskarqlik]

You can install the MySQL odbc connector and then  you can create a system (or user) DSN connection in windows ODBC manager. Just make sure to configure correctly either 32 o 64 bit.

Later, From Qlik Sense you can access to MySql with a specific user credentials. You need to check ON THE DATABASE this user has the reading rights.

[rajendra1918]

Ok Thank you Bhaskar.

I have already installed MYSQL ODBC 3.1 and this is working fine. But i am trying to use mysql enterprise edition to connect the same.