Bug #14447 add USERNAME_LENGTH to ./configure
Submitted: 28 Oct 2005 23:13 Modified: 24 Jul 2006 23:40
Reporter: Gabe Jackson Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:ALL OS:Any (ALL)
Assigned to: CPU Architecture:Any

[28 Oct 2005 23:13] Gabe Jackson
16 Char username limitation is very annoying if you are running a hosting site with domain names as usernames.

Please add a configure option to ./configure to set USERNAME_LENGTH in:
include/mysql_com.h:#define USERNAME_LENGTH 16
and also in the privileges_table script ALTER TABLE `user` MODIFY `User` VARCHAR(valueFromConfigure) BINARY

I've tested this approach with success:
set USERNAME_LENGTH to 20, recompiled, altered the privilges table to VARCHAR(20) BINARY

made new db test_db, grant:
mysql> GRANT ALL ON `test_db`.* TO '123456789012345678'@'localhost' IDENTIFIED BY 'my_pass';
Query OK, 0 rows affected (0.00 sec)

fileserver ~ # mysql -u 123456789012345678 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.25

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


So this seems to work. i'm not sure if anything else is involved, but would be nice to have this as a configure option since 16 is really short, and i don't see a reasoning for it in the manual either.

How to repeat:
GRANT ALL ON `test_db`.* TO '123456789012345678'@'localhost' IDENTIFIED BY 'my_pass';
on a normal installation ->
ERROR 1145: The host or user argument to GRANT is too long

Suggested fix:
mentioned above
[28 Oct 2005 23:18] MySQL Verification Team
Changed to feature request.
[24 Jul 2006 23:40] Jim Winstead
This is a duplicate of Bug #3083.