Re: change user name from 16 to 64 charactors

Matthew <[email protected]> Wed, 25 May 2016 08:50:14 -0500
Newsgroups	gmane.comp.db.mysql.devel
Message-ID	<[email protected]>
--------------ms070304010609030807040905
Content-Type: multipart/alternative;
 boundary="------------B3D27235A8FEC6556B0A645B"

This is a multi-part message in MIME format.
--------------B3D27235A8FEC6556B0A645B
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: quoted-printable

Just an FYI, MySQL 5.7 includes support for usernames to 32 characters.=20
Your codebase implies your are working on an older version of MySQL and=20
if you simply needed longer username support, it might be easier to just =

upgrade to 5.7 rather than tweak the code.

Example:
  mysql57> GRANT USAGE ON *.* TO=20
'abdjfhduehfjdhesuthcjdiejgjgjgi2'@'localhost' IDENTIFIED BY 'fo';

Cheers,
Matthew

On 5/24/16 10:17 PM, northhurricane wrote:
> Hi
>
> I did some changes on mysql code and want to contribute it. But I am a =

> newbie and don't know whethe these changes are correct.
>
> Attached file contains the modification. Can anyone help me out? Or=20
> give me some advise.
>
>
>
>
>
>


--------------B3D27235A8FEC6556B0A645B
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta content=3D"text/html; charset=3Dwindows-1252"
      http-equiv=3D"Content-Type">
  </head>
  <body text=3D"#000000" bgcolor=3D"#FFFFFF">
    Just an FYI, MySQL 5.7 includes support for usernames to 32
    characters. Your codebase implies your are working on an older
    version of MySQL and if you simply needed longer username support,
    it might be easier to just upgrade to 5.7 rather than tweak the
    code.<br>
    <br>
    Example:<br>
    =A0mysql57&gt; GRANT USAGE ON *.* TO
    'abdjfhduehfjdhesuthcjdiejgjgjgi2'@'localhost' IDENTIFIED BY 'fo';<br=
>
    <br>
    Cheers,<br>
    Matthew<br>
    <br>
    <div class=3D"moz-cite-prefix">On 5/24/16 10:17 PM, northhurricane
      wrote:<br>
    </div>
    <blockquote
      cite=3D"mid:[email protected]=
om"
      type=3D"cite">
      <div
        style=3D"line-height:1.7;color:#000000;font-size:14px;font-family=
:Arial">
        <div>Hi</div>
        <div><span style=3D"line-height: 1.7;"><br>
          </span></div>
        <div><span style=3D"line-height: 1.7;">I did some changes on mysq=
l
            code and want to contribute it. But=A0</span><span
            style=3D"line-height: 23.8px;">I am a newbie and don't know
            whethe these changes are correct.</span></div>
        <div><br>
        </div>
        <div>Attached file contains the modification. Can anyone help me
          out? Or give me some advise.</div>
        <div><br>
        </div>
        <div><br>
        </div>
      </div>
      <br>
      <br>
      <span title=3D"neteasefooter">
        <p>=A0</p>
      </span><br>
      <fieldset class=3D"mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap=3D"">
</pre>
    </blockquote>
    <br>
  </body>
</html>

--------------B3D27235A8FEC6556B0A645B--

--------------ms070304010609030807040905
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExDzANBglghkgBZQMEAgMFADCABgkqhkiG9w0BBwEAAKCC
BoUwggaBMIIEaaADAgECAgMPQ9AwDQYJKoZIhvcNAQELBQAweTEQMA4GA1UEChMHUm9vdCBD
QTEeMBwGA1UECxMVaHR0cDovL3d3dy5jYWNlcnQub3JnMSIwIAYDVQQDExlDQSBDZXJ0IFNp
Z25pbmcgQXV0aG9yaXR5MSEwHwYJKoZIhvcNAQkBFhJzdXBwb3J0QGNhY2VydC5vcmcwHhcN
MTQwNzExMjEwODIyWhcNMTYwNzEwMjEwODIyWjBBMRYwFAYDVQQDEw1NYXR0aGV3IEJvZWht
MScwJQYJKoZIhvcNAQkBFhhtYXR0aGV3QG1hdHRoZXdib2VobS5jb20wggIiMA0GCSqGSIb3
DQEBAQUAA4ICDwAwggIKAoICAQDjWjlUkfV0Z/I7cfpUB+sS31y8WxFOdZUGHtl1ti5cJ8mf
nfwBrmgNiKzeICEFTxaE6bxhVu+M58BNGw6nlD4DeznCZgvv1MJWSh4UxXNZsP3G2JlLwQdU
spJIW8431Tt35cztKk031DHbdxlPcGtWeM1uEbAQRu1D2z7rVwXRRJBrJkv3op14PBEZ4YHJ
z0wQtBHTsj5PP9hg7QPZSv8C4Xdwlv0TLgUfzigNiy2FbCVPIHMEWcPT6Cgo3+sgAP7Wsqjx
0CT4xaYWsPv5C//+YL8WXdS2FYTrcXzKAOME242P0gvRT0wv7ApNkRqm48V/tyWJKLtKtsHq
HF3uCKUzYZNcZtVz3yW22wZXXxUW4mQsyr3C3e0uOt0Dc5db5vzeHekQu4QxGKQHtGZwBKlY
fBVTifrg/BEGvS/8KyIAlljS+/qDKTI28Tj15BYaZZlmHCrvf31mOmA+yHoLydqH4Qld3uEK
Aid9f1hF8ooTGX1JH5D1uO/D/hQ/5g/oQYABBWuwKIoimBy5826nnN+XA5aC7FJAC4v8b891
SPQKkCzBunN0Oqhesv/EN8Y5SuCviIavrQ7OBLA5oYKdukf5+ZZ1YaPweQNu/6O4FpWB+Bge
Z6ox0G28Eju4lTnYSQLm2JfBNDdHyoAYpy4L0lQb97Mq+iftTostr+aezbhN0wIDAQABo4IB
SDCCAUQwDAYDVR0TAQH/BAIwADBWBglghkgBhvhCAQ0ESRZHVG8gZ2V0IHlvdXIgb3duIGNl
cnRpZmljYXRlIGZvciBGUkVFIGhlYWQgb3ZlciB0byBodHRwOi8vd3d3LkNBY2VydC5vcmcw
DgYDVR0PAQH/BAQDAgOoMEAGA1UdJQQ5MDcGCCsGAQUFBwMEBggrBgEFBQcDAgYKKwYBBAGC
NwoDBAYKKwYBBAGCNwoDAwYJYIZIAYb4QgQBMDIGCCsGAQUFBwEBBCYwJDAiBggrBgEFBQcw
AYYWaHR0cDovL29jc3AuY2FjZXJ0Lm9yZzAxBgNVHR8EKjAoMCagJKAihiBodHRwOi8vY3Js
LmNhY2VydC5vcmcvcmV2b2tlLmNybDAjBgNVHREEHDAagRhtYXR0aGV3QG1hdHRoZXdib2Vo
bS5jb20wDQYJKoZIhvcNAQELBQADggIBADUqEtTnAEcp0oT/DgiXOip4v5XXLvB/nFBjA+pd
ESSHHPzqYrRAWC58+u9B3pHifCkpYA0fth6Gs5xlapGaENmYUioJY5LPfwh50H0amagaPOWa
kYGj1BGGQqNoLtzvopdTk0zh8nPRvzNKhynod5qk+uI84KTg4jZvkrdulAZbWNbxXjvs7BNS
z6V78ZbAtHhXGiaFW4VPFqXQUThVZCeQkNFjHXO5OjQysr7Rup/kL6HysOhTAnKGPIY9o67l
gmPLfy0kPFzgACfynDA/ZAJoecys7k1oeV4yhDzJHChjW03W7r6nOCbs8GV8cTMKAQ2328c5
zVjnyff8Mntc5a94YcBUz5saF0o1g2Oa/PlQbuwitHGDmNMSicBWI4c671tei8FslmDnLaq4
fujZGTumjhz8lgGM5JMAh4bOpTEA+7qXJJeO6AiyliLg3fMHuI+RFgLyI/o9EghtmSQEva9m
qFHASbShw0V/utu3iMIn3dlROgG8Juikb4DlICudo8S3cpEqFKNJXM9gK7BobE9rFNyJ03d2
xhQohp3BwpnbsHQ7HJYFC0OM2laGU7WQmbjgN14agtQd/ecTIrcU6diDveUw+sFNOP6pqtgW
8LC8XTCQ5IdtTZfDHJCI4D8CDZ/0PROBJ2klwwXZZYQviN6IRPLXnyiLjrHSciScMz6LMYIE
0TCCBM0CAQEwgYAweTEQMA4GA1UEChMHUm9vdCBDQTEeMBwGA1UECxMVaHR0cDovL3d3dy5j
YWNlcnQub3JnMSIwIAYDVQQDExlDQSBDZXJ0IFNpZ25pbmcgQXV0aG9yaXR5MSEwHwYJKoZI
hvcNAQkBFhJzdXBwb3J0QGNhY2VydC5vcmcCAw9D0DANBglghkgBZQMEAgMFAKCCAiEwGAYJ
KoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTYwNTI1MTM1MDE0WjBP
BgkqhkiG9w0BCQQxQgRAYNHXkl9pV2WITUTpXKhqfbE0hxiKNovjwXXSiWz9aQFYBavPrvIC
V5fWA4OYXDQVB42O/iuZGk0WELFOrNdpdDBsBgkqhkiG9w0BCQ8xXzBdMAsGCWCGSAFlAwQB
KjALBglghkgBZQMEAQIwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMC
AgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMIGRBgkrBgEEAYI3EAQxgYMwgYAweTEQMA4G
A1UEChMHUm9vdCBDQTEeMBwGA1UECxMVaHR0cDovL3d3dy5jYWNlcnQub3JnMSIwIAYDVQQD
ExlDQSBDZXJ0IFNpZ25pbmcgQXV0aG9yaXR5MSEwHwYJKoZIhvcNAQkBFhJzdXBwb3J0QGNh
Y2VydC5vcmcCAw9D0DCBkwYLKoZIhvcNAQkQAgsxgYOggYAweTEQMA4GA1UEChMHUm9vdCBD
QTEeMBwGA1UECxMVaHR0cDovL3d3dy5jYWNlcnQub3JnMSIwIAYDVQQDExlDQSBDZXJ0IFNp
Z25pbmcgQXV0aG9yaXR5MSEwHwYJKoZIhvcNAQkBFhJzdXBwb3J0QGNhY2VydC5vcmcCAw9D
0DANBgkqhkiG9w0BAQEFAASCAgA/4G1VhrClbElw/qFNKtW7Mmitzz6t+dyDZ0pBg730gWCO
sW4sVr/9c0Vf+7e10j71p11BsZIg9x2a8R3/Qr15jf0U+2dgWDV/8Ya/PJV9dsWuta9YfkIp
qndV1yKFfIpDMrSqfOwu3BQXht9fDopPBtBmsGGzivTC8vMKOve51UU6QLhvJLEYbKfBq9/Y
x5QQofOulJLfJwJlDicSnIIxVKo8BV35ytB50xt3wamiXHNwg1pem6ec1ZZbJ/PJ05d3/20q
PGBc9zlyDWwS4VQGekZkbis4CNkhP6VFqJC1Yf+d2o5hSpN55XV/IqSuML7yqB/FpoaC7A7i
qRSMPsHWxiXgsFppoTXXADibQKlKDy93CUYjw14yZ1Ii6xbtHOeCU+zpkUkaK3z3b/RN9ehG
qGDuwKsLHBlqVzvv7G/o3NAaeeq7j7VH1g3fFJ/KvkB4eFCByIDLfWqpaq807auXtBzlL8vk
zad/Se/YLUsakxS/6ne+D1SnvcbvPAgTq7lyvyyb/ShcHLqEX5fwMNxc4DUhrMTA3Y/OCf1w
x/516VcIWUus9ni3PpSElvXAvC7Wx8J4tu/X+cx3hDytztVhBMvt6C0M34P0Onns8e95KdSq
b2w7kGdgGzzT//F19wmDFWSG9he9HNLXtp2+rFFKMTh9ZXghqfhFpBkzfZ5y2wAAAAAAAA==
--------------ms070304010609030807040905--