Hello,

is it possible to switch off length limit (16 chars) for username in
mysql? I get an error '1145 (42000): The host or user argument to GRANT
is too long' in GRANT command.

I modified User column in both tables (db and user) to char(64) and
manage users and rights on my own, but it isn't best way.

thanks for any advice,
Andrew

opio wrote:
AFAIK, user names are restricted to 16 characters. You'll probably have
to modify the MySQL code to change it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Jerry Stuckle wrote:
I guess you could have a table of pseudo-users(pseudo-user
-encrypted?,username) that mysql could use to establish the correct 16
character username prior to determining access. I haven't had this
problem myself so I'm really just thinking out loud.