World: r3wp

This one should work : http://softinnov.net/tmp/mysql-protocol.r

still beta, need some more testing to make it 1.0

the link is dead

http://softinnov.org/tmp/mysql-protocol.r

was the bad handshake problem ever solved? I'm getting it here.

Workaround found for v4+ servers version, still testing for v3.x 
 versions.

so no hope for 5.0 just yet?

It should work correctly for 5.0.

would this be with support for old passwords enabled?

The driver detects the server version, if it is 4 or above, it use 
the new passswords, if it is 3.x, it uses old passwords.

If you want v5 with old password, I have to provide an option to 
allow that.

I had old passwords enabled because I thought it didn't support that 
:-)

:-)

but I still get the bad handshake

Which server version ? How password was created ?

server 5.0.21

I used mysql-admin to create the user. I don't know which method 
it uses

Thanks, I'll try with 5.0.21 + mysql-admin.

looks like mysql-admin doesn't use PASSWORD() to create passwords

that's the problem

works when I set it with PASSWORD()

hope that helps a bit

Sure it helps, thanks!

I'll try to release an updated version this weekend that fix such 
case.

excellent

dumb question.. is this a valid query?

select i1.id,i1.ip,i1.session from isa i1,isa i2 where i1.ip=i2.ip 
and i1.session<>i2.session order by i1.ip
about 70'000 records in isa
running this query seams to crash/block the mysql server..

not a well constructed query. unless my mental parser isn't working. 
You are asking for each and every row where it doesn't match the 
current row... now I don't think that is your true intent ...

that would be something like 70,000 * 70,000 results

valid but not like useful , (or likely to finish soon)

stating what you actually want to accomplish could help

Henrik: Can yo give me the mysqladmin command line you're using to 
create a new user ?

mysql-admin is a GUI client.

I'll see if I can find some docs on it. it's the client you can download 
from mysql.com

Ok, so you mean MySQL Administrator (and not the mysqladmin.exe command 
line tool).

it's called "mysql-admin" under linux. looks like your name is correct.

http://dev.mysql.com/downloads/administrator/1.1.html<--- that one

Tried creating a user using that tool under WinXP and OSX, then I 
tried connecting with mysql-protocol.r => no problem...

if you look in your user table, what length is the encrypted password?

*63D85DCA15EAFFC58C908FD2FAE50CCBC60C4EA2

ok, mine are only about 16 chars long

so it's simply a different encryption scheme for some reason

when I created it from the console, I got a properly encrypted password 
like yours

16 chars are old passwords IIRC

I think the client is confused about that. The error log for it says 
that old passwords are not supported for 5.0. I initially tried to 
turn old passwords on, because I didn't think mysql-protocol.r supported 
newer ones.

then I tried to turn them off again through the GUI and it didn't 
change.

Could you activate : trace/net on before using mysql:// and show 
me here the server information retrieved by the driver.

that'll take a short while, the PC that the mysql server is on has 
been taken down. :-)

Ok, I see...no problem, just post it here when you'll have the log.

setting it up now (need to do it anyway)

imo it is like this - when you have db created with old scheme, db 
will not automatically rebuild it for you using new method ...