connecting MySql Database on linux platform

[mdmukramali]

Dear Community,

I have Mysql database on linux server which is on public ip.

     Qlikview is running on my  windows machine.

please somebody guide me how to connect mysql database from qlikview.

(procedure for creating ODBC connection on linux server).

i highly appreciated your help.

Thanks,

Mukram.

[datanibbler]

Hi Mohammed,

well, there should be ODBC connectors available for Linux - depending on which distro you have... just have a look, there's plenty of sites around with OSS for Linux.

The procedure from QlikView then is the same as for a Windows-hosted SQL database, you can use SQL in QlikView - or there's even a Wizard to both connect (create a connect_string in the script) and select data.

Best regards,

DataNibbler

[mdmukramali]

Dear ,

On Linux server mysql version:  MySQL 5.0.95.

so do i need to install the same mysql 5.0.95 connector on my machine?

Thanks,

Mukram.

[mdmukramali]

Dear,

I try to connect it but I'm getting the below error.

somebody help me to solve the issue.

Thanks,

Mukram.

[#5]

Hi Mukram,

'secure_auth' enable

Can you resolve the problem with the conection?

I´m getting the same issue.

Best regards,

Angel

[nidhibatra10]

Hey,

Did you get any solution to this?

Thanks,

Nidhi Batra