Professional Web Applications Themes

userhost length limit in GRANT - MySQL

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

  1. #1

    Default userhost length limit in GRANT

    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 Guest

  2. #2

    Default Re: userhost length limit in GRANT

    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]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

  3. #3

    Default Re: userhost length limit in GRANT


    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]jstucklexattglobal.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.

    strawberry Guest

Similar Threads

  1. Limit on maximum String length?
    By Heman Robinson in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: April 19th, 05:34 PM
  2. Anydata CSV format length limit?
    By John Brooking in forum PERL Modules
    Replies: 1
    Last Post: March 7th, 11:53 AM
  3. stored proc 128 length limit
    By AJ in forum ASP Database
    Replies: 13
    Last Post: September 22nd, 06:59 PM
  4. URL length limit ?
    By FabienV in forum ASP
    Replies: 2
    Last Post: August 11th, 11:48 AM
  5. How can i grant priviledge to user joaquin???
    By joaquin in forum Oracle Server
    Replies: 1
    Last Post: December 27th, 06:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139