On Mon, 10 Mar 2003 10:41:15 -0600 Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 14:35 +0100 3/10/03, Chand wrote: > >hey dudes, i'd really need some insight on this. Does anyone have > >any idea about this ? > > > >TIA > > > >heya, > > > >I have a quick and painless (i hope :) )question.. > > > >Do you know how the username length is limited under MySQL. There is > >no mention of this in the manual or books. I figured the username > >length was dynamically limited by the length of the User field in > >the mysql.user table. > > The length is described in the manual in this section: > > http://www.mysql.com/doc/en/Privileges.html > > It indicates that usernames are stored in a 16-character column. > You can also issue a DESCRIBE mysql.user statement to find out. heya, thanks for the answer although i know how to get that info. But that's not very accurate, for example i could do an alter table and make the User field be 80 characters. It still wouldn't change the fact that Mysql Hard limits in the code the Login size to 16 which in my mind seems pretty harsh. I've patched it roughly for my needs by defining USERNAME_LENGTH to 80 in include/mysql_com.h but it doesn't really fit me cause next time i'll upgrade mysql, I'll have to patch it again. Don't you guys see the disadvantage of hard limiting so badly the Daemon ? Is there any plan to change this in the future ? Just my 2 cents. -- Chand "Speed is good but stability is god." (c) Joel, 2003 "En réalité, nous sommes tous morts... Mais c'est camouflé par la vie" (c) Lewis, 2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
