Documentation Home
MySQL Internals Manual


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
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.