How to login with Authentication protocol

klchin · Post by **klchin** » 29.05.2007, 02:29

Hi everyone,

SQL Error : Client does not support authentication
protocol request by server; consider upgrading MySQL client.

Any sample code to resolve above problem.

Regards,
KL Chin

Post by **mdaems** » 29.05.2007, 22:33

This problem is caused by the new authentication protocol used by mysql. So it's not really zeoslib related. As far as I know it can be solved in 2 ways:
- Start your server with the old authentication enabled (see mysql docs)-> if you're not the dba this probably will not be allowed.
- Use a newer dll. Problem here is the zeoslib 6.1.5 version you're using. I'm afraid the interface with a mysql 4.1 dll isn't working. You could try to rename an early 4.1 dll, but it's not very likely to work. -> Upgrading to zeoslib 6.6 will probably be unavoidable.

Mark

klchin · Post by **klchin** » 30.05.2007, 02:22

Hi Mark,

Thx for your suggestions.

You are right, renaming the dll does not worked.
I yet to test old authentication, but current I just delete the password.

How stable ver 6.6 as compare to 6.1.5?
Any major coding changes, i.e. the name.

Regards,
KL Chin

Post by **mdaems** » 30.05.2007, 11:33

Should be more stable, is what I hear on the forum. I can't compare as I only entered when 6.5.1 alpha was available.

Mark

klchin · Post by **klchin** » 31.05.2007, 03:01

Hi Mark.

Again, thx for your reply.

It should be better, but I'm most worried about the memory
leakages, (mainly I only used the basic feature and query), other
bugs no so impoartant. Beside, I do followed the forum threads daily,
I understand still many bugs not resolve, that the reason I still
used 6.1.5. But will change when time come.

Some bugs occur on 6.1.5 I don't know it still in 6.6, which I post
on the different thread, i.e. why the TZQuery cannot change the
RequestLive at runtime.

http://zeos.firmos.at/viewtopic.php?t=1184

Regards,
KL Chin