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
• Status: Duplicate
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• Version: 5.5.28
• OS: Linux (ubuntu server 12.04)
• CPU Architecture: Any
• Tags: LENGTH, maximum, username

[28 Nov 2012 14:30] Sam Caldwell

Description:
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