mysql authentication error

[d.ghisla]

Hello,

I am using sqltoolkit. It works very good on remote, but I have a problem when I try to work on my PC ( localhost )

I am  using Mysql server 5.0 , and when I try to connect I got this message:

"Client does not support authentication protocol requested by server;consider upgrading MySql client"

I am using this parameters to connect SQL:   

    #define SQL_SERVER "localhost"
    #define SQL_USER   "username"
    #define SQL_PASSWORD "mypassword"
    #define SQL_DBNAME "dbname"

Do you have any idea?

Thanks

Daniele

[LiciaP]

Hi Daniele,

you stated that your program run on remote: what exactly do you mean? Which parameters did you use on the remote PC?

Are you able to run CVI examples and correctly connect to a database?

What did you install on the different PCs?

Bye,

Licia

[d.ghisla]

Ciao Licia,

With remote I mean that my application is able to connect to mysql database on remote server, but when I try to connect with  Mysql server on  my PC doen't work and I got the message error wrote above. MySQL server (version 5.0) work correct with other application (i.e. Web application ) but not with my CVI app.

Ciao

Daniele

[LiciaP]

Ciao Daniele,

MySql server is the same?

Licia

[d.ghisla]

Yes Licia, Mysql server for both systems.

Thanks Daniele

[LiciaP]

I'm sorry, I meant the version...

Bye!

Licia

[d.ghisla]

MySQL server 5.0 on both system I mean.

I am sorry for my  imprecision

Daniele

[mjl]

Hi,

     Are you able to connect up to it using the MySQL Browser?  If you use a Web application it is going through the Apache server, not directly to the MySQL daemon.  Are you using the MySQL API or NI SQL Tool Kit?

Mike

[d.ghisla]

Hi Mike,

I don't use API, but NI SQL Tool Kit.

For my web application I use Apache and PHP and work without problem on localhost.

When I set in my CVI app the parameter for MYSQL connection on LOCALHOST I received the error wrote above...

Thanks

Daniele