MySQL Bugs: #3083: User length limitation

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:	None
Category:	MySQL Server: Security: Privileges	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

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

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.

Bug #16553 contains a patch for allow this to be user-configurable at compile time.

http://bugs.mysql.com/bug.php?id=67742 is a duplicate of this

Do you have plans to fix this soon?

Thanks you for your time in advance,

+1

I would like to be able to use full email addresses for usernames

This has been increased to 32 characters in MySQL 5.7.8 (not yet released):
http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html

Posted by developer:
 
Release notes already document this change as implemented.  Closing this bug.