List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 13 2003 3:16pm
Subject:Re: The host or user argument to GRANT is too long ??!!!
View as plain text  
At 11:25 +0100 3/13/03, boka wrote:
>Hi !
>
>I have tried to find a solution to my problem on groups, FAQs, with no
>effect.
>
>GRANT Select,Insert,Update,Delete ON `sprzet`.* TO
>     -> 'azsxdcfv_azsxdcfvgb'@'azs.azsxdcfvg.az';
>ERROR 1145: The host or user argument to GRANT is too long

Use a shorter user name.

I assume you wanted a different answer than that?

>
>hmm ...
>
>mysql> show columns from user;
>+-----------------+-----------------+------+-----+---------+-------+
>| Field           | Type            | Null | Key | Default | Extra |
>+-----------------+-----------------+------+-----+---------+-------+
>| Host            | char(60) binary |      | PRI |         |       |
>| User            | char(50) binary |      | PRI |         |       |
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

The original User column length is 16 bytes.  Did you widen
it in an attempt to get longer user names?

>...
>
>conf:
>MySQL-3.23.55
>
>--
>May the source be with you...
>Pozdrawiam
>mailto:boka(at)sto-procent.art.pl

Thread
The host or user argument to GRANT is too long ??!!!boka13 Mar
  • re: The host or user argument to GRANT is too long ??!!!Egor Egorov14 Mar
Re: The host or user argument to GRANT is too long ??!!!Paul DuBois13 Mar