Bug #57300 Unhandled exception when attempting to add an account
Submitted: 7 Oct 2010 8:55 Modified: 30 Dec 2010 14:45
Reporter: Network Limited Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.29 CE Revision 6756 OS:Windows (7 Ultimate x64)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: error

[7 Oct 2010 8:55] Network Limited 
Description:
Error message that appears:
"Unhandled exception: Could not load account information for XXXXXXXXXXXXXXXXX@localhost"

How to repeat:
Attempt to add an account with a "Login Name" longer than 16 characters

Suggested fix:
Handle the exception and display a meaningful error message.
e.g. Login names are restricted to a maximum of 16 characters. This is a hardcoded server side limit that cannot be changed.
[7 Oct 2010 9:26] Peter Laursen 
User names in MySQL are up to 16 characters long - and not longer. 

http://dev.mysql.com/doc/refman/5.1/en/user-names.html

Peter
(not a MySQL person)
[7 Oct 2010 13:20] Network Limited 
This issue is not that more than 16 characters should be allowed. But that the exception handling and thereby corresponding error messages need to be improved.
[7 Oct 2010 14:12] Valeriy Kravchuk 
More specific error message is needed for this case.
[13 Oct 2010 13:35] Johannes Taxacher 
Could you please try with latest version if the problem still exists, and if so, please add a step-by-step example on how to reproduce the problem.
thanks in advance
[13 Oct 2010 14:22] Network Limited 
Sure, and yes it does still occur with the latest version.

To reproduce:
- "Add account"
- Fill in a "Login name" longer than 16 characters
- Complete "Password", "Confirm Password" and "Limit Connectivity to Hosts Matching" fields
- Click "Apply"
[14 Oct 2010 13:08] Daniel Pfirrmann 
After the first error message you always get error messages even if you shorten the name to a allowed length.
[14 Oct 2010 14:06] MySQL Verification Team 
Bug http://bugs.mysql.com/bug.php?id=57452 marked as duplicate of this one.
[26 Oct 2010 22:36] Alfredo Kojima 
Added a hard limit of 16 chars to the length of the username text entry.
[27 Oct 2010 8:08] Network Limited 
Perfect, I'll test it again when an update is available.
[8 Dec 2010 21:31] Johannes Taxacher 
fix confirmed in repository
[30 Dec 2010 14:45] Tony Bedford 
An entry has been added to the 5.2.31 changelog:

In the Administrator, when attempting to add an account with a login name longer than 16 characters, an exception was generated.