Bug #3168 When register server, user name can not exceed 16 charactors

• Submitted: 14 Mar 2004 13:03
• Modified: 14 Mar 2004 14:16
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQLCC
• Severity: S1 (Critical)
• Version: 0.9.4
• OS: Windows (Win32)
• CPU Architecture: Any

[14 Mar 2004 13:03] [ name withheld ]

Description:
When you register a server, you need to specify 
- Host Name
- User Name
- Password
- Port
...
When you give a user name which exceeds 16 characters, you will get a connection failure to the server. 

In 0.9.2, there is no this problem.

How to repeat:
Create a user with user name more than 16 characters. Then register a server with that user. When you try to connect, you will see the problem.
 

Suggested fix:
Do not limit user name length for so short.

[14 Mar 2004 14:16] MySQL Verification Team

Use the prompt client and you should the reason:

mysql> grant all on *.* to "my_long_name_user_for_make_test"@"localhost"
    -> identified by "nothing";
ERROR 1145: The host or user argument to GRANT is too long
mysql> grant all on *.* to "my_long_name_use"@"localhost"
    -> identified by "nothing";
Query OK, 0 rows affected (0.00 sec)

mysql> desc user\G
*************************** 1. row ***************************
  Field: Host
   Type: char(60) binary
   Null:
    Key: PRI
Default:
  Extra:
*************************** 2. row ***************************
  Field: User
   Type: char(16) binary
   Null:
    Key: PRI
Default:
  Extra:
*************************** 3. row ***************************

[15 Mar 2004 12:27] [ name withheld ]

If it's not a bug, then what happened. 

I host a web in a web hosting company which uses MySQL. I use MySQLCC to manage the database remotely. Recently I installed 0.9.4, then I found it had problem with my user name which exceeds 16 characters when I register server. Then I uninstalled 0.9.4, and installed 0.9.2 beta. It works fine. 

If it were the database's problem which limited the user field as 16 characters only, why 0.9.2 can work with a long user name which should have cause problem other than 0.9.4.