Bug #9866 User name is truncated if longer than 16 charachters
Submitted: 13 Apr 2005 11:36 Modified: 4 Aug 2006 11:31
Reporter: Cassim Farook Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.19 upwards even in 1.0.20 OS:
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[13 Apr 2005 11:36] Cassim Farook 
Description:
When the administrator tries to connect to a server using username@ipaddress with a password, it truncates the username to 16 chars. 

How to repeat:
create a database username that is larger than 16 characters example: dbm.mydomainname.biz and try to connect via MySQL Adminstrator 1.0.20 or MySQL Query Browser version 1.0.16.
[13 Apr 2005 21:45] Jorge del Conde 
Thanks for your bug report
[26 Apr 2005 19:10] Michael G. Zinner 
Please take a look at the mysql.user table. You will see that the user name is actually a CHAR(16) column. There is nothing the MA can do about that.

We will add a warning that more that 16 chars are not allowed in the Admin.