Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL user name is too long error

Discussion in 'Database Discussion' started by robahas, Apr 27, 2019.

Tags:
  1. robahas

    robahas Member

    Joined:
    Apr 27, 2019
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    I just crated a new installation of WHM and I'm copying accounts from another cPanel installation. I am getting this message:

    The system cannot grant privileges to the MySQL user “example_something” because of an error: (XID sqxnev) “example_something” is too long by 1 character. A MariaDB/MySQL username cannot exceed 16 characters.

    I get the problem, and the solution is to address the too long name either before or after transfer. However, I'm confused about how this even happens. If cPanel does not allow user names that are longer than 16 characters, how did that user name get created in the first place? Is this a bug? I do recall some times in the past receiving a notice that my user name was too long. But I don't recall this in recent memory. Now it typically seems to accept any length (I've created many many cPanel accounts in my day), and I've thought: oh, I guess I can use longer names now. Cool!

    Also, I'm wondering if there is a better solution than mucking around in the account and changing the user name in the application, etc. This is a fly in the ointment of the transfer process, which is so smooth and useful, and just wonderful.

    Cheers
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,335
    Likes Received:
    2,162
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice