Re: Client Authentication Packet w/ databasename

[Konstantin Osipov]

* Baron Schwartz <baron@stripped> [09/04/12 07:12]:
> According to
> http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Client_Authentication_Packet
> 
> If the client authentication packet includes the initial database, it
> is preceded by a 0x00 filler byte.  What I'm seeing in tcpdump doesn't
> seem to match that.  Here's what I see, with the packet header
> omitted:
> 
>
> 8da20300000000010800000000000000000000000000000000000000000000006d73616e64626f7800143e05bd06881b5c515a527f5228ccd1afe13ba6a86d7973716c00
> 
> Which as I see it, is 'msandbox'  (6d73616e64626f78) trying to connect
> to 'mysql' database (6d7973716c00).  The scramble buffer is a
> length-coded binary that precedes 'mysql', but there's no 0x00 byte in
> between the scramble buffer and the database name as the wiki page
> states.
> 
> It's a wiki; I feel like I should just fix it myself, but wanted to
> check here first :)

Depends on whether the old (pre 4.1) or new authentication protocol is used.

--