Bug #24353 After creating user and then querying the user_privileges table,server stoped!
Submitted: 16 Nov 2006 8:48 Modified: 21 Nov 2006 16:53
Reporter: leo Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.12-beta-nt OS:Windows (windows 2000)
Assigned to: CPU Architecture:Any

[16 Nov 2006 8:48] leo
Description:
this happens when length of user's name and host'name to be create exceeds the limits.  

such as user is 'localhostlocalhostlocalhost'.
Host is 'tt1234567890123456789012345678901234567890123456789012345678901234567890'.

Excuting this operation.no exception is showed.

then querying the user_privileges of information_schema database,after that,server will stop.

so you must restart the service.

How to repeat:
1)sqlcli -u root -p
2)create user 'localhostlocalhostlocalhost'@'tt1234567890123456789012345678901234567890123456789012345678901234567890'
3)select * from information_schema;
[16 Nov 2006 8:55] leo
How to repeat:
1)sqlcli -u root -p
2)create user
'localhostlocalhostlocalhost'@'tt12345678901234567890123456789012345678901234567
89012345678901234567890'
3)select * from information_schema.user_privileges;
[16 Nov 2006 23:05] Hartmut Holzgraefe
are you really using 5.0.12-beta-nt? not 5.1.12?
if so then you should try a more current release as 5.0.12 
is over a year old by now ...

can't reproduce this on current unix versions, i'm getting

mysql> create user 'localhostlocalhostlocalhost'@'tt1234567890123456789012345678901234567890123456789012345678901234567890';
ERROR 1570 (HY000): String 'localhostlocalhostlocalhost' is too long for user name (should be no longer than 16)

on 5.1.12, latest 5.0 and 5.1 source
[17 Nov 2006 2:21] leo
thank your help.
i download the 5.1.12,then repeat the above opration,and find that doesn't appear again.
[21 Nov 2006 16:53] Valeriy Kravchuk
So, this bug is not repeatable on latest versions of MySQL server.