user@host length limit in GRANT

[opio]

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

[Jerry Stuckle]

opio wrote:

> 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
>

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.
[email]jstucklex@attglobal.net[/email]
==================

[strawberry]

Jerry Stuckle wrote:

> opio wrote:

> > 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
> >

>
> 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.
> [email]jstucklex@attglobal.net[/email]
> ==================

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.