Bug #67742 Enhancement: Increase max username length from 16 to 40
Submitted: 28 Nov 2012 14:30 Modified: 30 Dec 2012 7:10
Reporter: Sam Caldwell Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.5.28 OS:Linux (ubuntu server 12.04)
Assigned to: CPU Architecture:Any
Tags: LENGTH, maximum, username

[28 Nov 2012 14:30] Sam Caldwell
I would like to suggest extending username maximum lengths from 16 characters to 40 characters.  This would allow usernames made up of hashes to be stored using SHA-1.

USE Case:

I am writing software that currently generates tokenized usernames and passwords when it is installed.  At present this involves a random numbers and time stamps as we do not want to simply use predictable names made by some linear series.

If max length were 40-characters, the source code could contain human-readable usernames which could be stored in the database and used by the production software as SHA-1 hashes.  This better secures the server and also allows a greater number of unique human-readable usernames to be generated.

How to repeat:
not necessary

Suggested fix:
see above
[30 Dec 2012 7:10] MySQL Verification Team
Duplicate of http://bugs.mysql.com/bug.php?id=3083