topic Re: connecting MySql Database on linux platform in QlikView

connecting MySql Database on linux platform

mdmukramali — Wed, 09 Apr 2014 06:53:19 GMT

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.

Re: connecting MySql Database on linux platform

datanibbler — Wed, 09 Apr 2014 07:01:27 GMT

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

Re: connecting MySql Database on linux platform

mdmukramali — Wed, 09 Apr 2014 08:40:52 GMT

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.

Re: connecting MySql Database on linux platform

mdmukramali — Wed, 09 Apr 2014 09:33:30 GMT

Dear,

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

somebody help me to solve the issue.

Thanks,

Mukram.

Re: connecting MySql Database on linux platform

Thu, 06 Nov 2014 22:32:07 GMT

Hi Mukram,

'secure_auth' enable

Can you resolve the problem with the conection?

I´m getting the same issue.

Best regards,

Angel

Re: connecting MySql Database on linux platform

nidhibatra10 — Tue, 26 Feb 2019 12:52:55 GMT

Hey,

Did you get any solution to this?

Thanks,

Nidhi Batra