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: | |
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
[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.