Bug #3083 User length limitation
Submitted: 6 Mar 2004 10:07 Modified: 8 Jul 2015 13:53
Reporter: Dracul Vlad Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[6 Mar 2004 10:07] Dracul Vlad
User length limitation

How to repeat:
User length limitation on new account creation

Suggested fix:
First of all, sorry for my english!

It could be great to remove (or enlarge)
the username length limitation.

Many people change the user field length (from 16 to 128)
in the mysql tables and change the source code to do this.

Why not do it in the next release!

Thanks in advance.
[1 Dec 2005 14:35] Valeriy Kravchuk
Thank you for a feature request. User name is still limited to 16 in MySQL 5. I think, a more common limit of 32 (or, 128, as for identifiers in SQL) is a reasonable feature to implement, as soon as MySQL support its own user accounts.
[24 Jul 2006 23:39] Jim Winstead
Bug #16553 contains a patch for allow this to be user-configurable at compile time.
[30 Dec 2012 7:11] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=67742 is a duplicate of this
[21 Jan 2013 14:45] Predrag Zecevic
Do you have plans to fix this soon?

Thanks you for your time in advance,
[4 Apr 2013 21:46] James Devine

I would like to be able to use full email addresses for usernames
[8 Jul 2015 13:46] Morgan Tocker
This has been increased to 32 characters in MySQL 5.7.8 (not yet released):
[8 Jul 2015 13:53] Morgan Tocker
Posted by developer:
Release notes already document this change as implemented.  Closing this bug.