Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 1.2Mb


14.12.4.1 Fast Path

  • set --default-authentication-plugin=sha256_password for the MySQL server:

    46 00 00 00 0a 35 2e 36    2e 37 2d 6c 6f 67 00 02    F....5.6.7-log..
    00 00 00 01 2d 4f 1d 32    56 16 4c 00 ff f7 08 02    ....-O.2V.L.....
    00 3f 80 14 00 00 00 00    00 00 00 00 00 00 63 07    .?............c.
    35 39 35 15 5c 5f 27 08    3a 27 73 68 61 32 35 36    595.\_'.:'sha256
    5f 70 61 73 73 77 6f 72    64 00                      _password.
    
  • set --default-auth=sha256_password for the MySQL client, provide it with the servers public-key with --server-public-key=... and login with a user whose account uses sha256_password:

    1d 01 00 01 85 a6 3f 00    00 00 00 01 21 00 00 00    ......?.....!...
    00 00 00 00 00 00 00 00    00 00 00 00 00 00 00 00    ................
    00 00 00 00 73 68 61 32    35 36 00 80 a2 77 34 40    ....sha256...w4@
    7e 15 37 ea 41 03 e9 d3    eb ac 66 1e cb 1a b1 79    ~.7.A.....f....y
    ed 16 49 e6 94 e7 77 c5    f8 9e 3b 94 4f b0 d4 4d    ..I...w...;.O..M
    3e 7d 63 4b 11 43 4e 12    9c 70 8d 4f 55 b0 f9 93    >}cK.CN..p.OU...
    5f 19 70 36 ea ca ac 10    3d 95 43 95 b8 cb 4b 3e    _.p6....=.C...K>
    93 cb 46 2c 0f 38 1b 0e    2e ee cd 06 6b 34 0d 2f    ..F,.8......k4./
    8a ef 98 1b 0a e1 58 2f    bf 93 24 ea 1d ba 68 04    ......X/..$...h.
    cd a9 c0 01 12 21 f8 f9    4a e2 e4 62 2b c7 99 98    .....!..J..b+...
    91 03 d3 f5 54 7a 27 97    9c 2e b7 37 73 68 61 32    ....Tz'....7sha2
    35 36 5f 70 61 73 73 77    6f 72 64 00 64 03 5f 6f    56_password.d._o
    73 05 4c 69 6e 75 78 0c    5f 63 6c 69 65 6e 74 5f    s.Linux._client_
    6e 61 6d 65 08 6c 69 62    6d 79 73 71 6c 04 5f 70    name.libmysql._p
    69 64 04 34 32 36 30 0f    5f 63 6c 69 65 6e 74 5f    id.4260._client_
    76 65 72 73 69 6f 6e 05    35 2e 36 2e 37 09 5f 70    version.5.6.7._p
    6c 61 74 66 6f 72 6d 06    78 38 36 5f 36 34 0c 70    latform.x86_64.p
    72 6f 67 72 61 6d 5f 6e    61 6d 65 05 6d 79 73 71    rogram_name.mysq
    6c                                                    l
    
  • get a OK_Packet back:

    07 00 00 02 00 00 00 02    00 00 00                   ...........
    

User Comments
Sign Up Login You must be logged in to post a comment.