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

[28 Oct 2005 23:13] Gabe Jackson
Description:
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.

mysql> 

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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.