PDA

View Full Version : Length of DB User Name <= 16 ?


Extrarius
11-07-2005, 11:51 AM
Is the limitation that mysql database user names be 16 characters or less an intrinsic limitation of mysql or a limitation imposed by some aspect of DirectAdmin? Is it at all possible to remove or circumvent this limitation?

It's a very annoying limitation - with a 9 character DA user name and the imposed _, it limits me to 6 characters which isn't quite enough for a meaningful name.

Extrarius
11-07-2005, 12:25 PM
Nevermind, I finally found this thread (http://www.directadmin.com/forum/showthread.php?s=&threadid=5544) after searching several times, and from it I foundGRANT Syntax (http://dev.mysql.com/doc/refman/5.0/en/grant.html) which specifies that it is a limit of MySQL.

Is there any posibility of future versions of DirectAdmin including a modified MySQL to allow longer names? Even though I'm only a user, I'd like to know if I can hope for such conveniences in the future so I can make sure my host keeps up to date =-)

jlasman
11-07-2005, 03:40 PM
Great idea. Don't know how easy it is.

I'll bring the thread to DA staff attention. Maybe they'll know or can figure it out.

But then it would limit us to use DA-specific MySQL installs.

Jeff