re: The host or user argument to GRANT is too long ??!!!

[Egor Egorov]

On Thursday 13 March 2003 12:25, boka wrote:

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

Because you changed length of User column manually. The length of the column 
User is 16, not 50.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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

Re: The host or user argument to GRANT is too long ??!!!

[Paul DuBois]

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


-
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