Skip to main content

MySQL username prefix not being truncated

DanH42
I noticed recently one of our cPanel servers (v58) has stopped truncating usernames for database prefixes. This reduces the number of characters left for usernames to sometimes only a couple characters, and for longer usernames completely prevents the creation of MySQL users: https://i.imgur.com/dfapo56.png
What could have caused this? How do I get the truncation back working the way it was?

Comments

6 comments

Date Votes
  • cPanelMichael
    Hello, This relates to the following change documented in the
    0
  • DanH42
    Check to see if the following directories exist on this system: /var/lib/mysql/.ssh /var/lib/mysql/.cpanel

    Neither of those directories exist in /var/lib/mysql, nor are there any other hidden directories. In addition to the length issue, I'm also unable to grant new privileges to users created before v56: https://i.imgur.com/qRenWnp.png
    In the image above, I'm trying to add grants for an old MySQL user called extremem_sso. Something is getting crossed somewhere, and cPanel is adding an additional prefix to the already-prefixed username, resulting in "extrememotors_extremem_sso" which isn't a real user. This happens whether I'm granting privileges on a newly created database or on one that has an old truncated prefix. Even if I can get the username length issue solved, this prefix mismatching is still going to be an issue.
    0
  • cPanelMichael
    Neither of those directories exist in /var/lib/mysql, nor are there any other hidden directories.

    Hello, Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here and I'll make sure the thread is updated with the outcome. Thank you.
    0
  • DanH42
    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here and I'll make sure the thread is updated with the outcome.

    Opened support request #7875831.
    0
  • DanH42
    After some great sleuthing by a couple cPanel support folks, it turns out the issue was related to a bug in the x3 theme, which we still used on all our servers. Switching an account over to Paper Lantern fixes both issues we were seeing.
    0
  • cPanelMichael
    I'm happy to see the issue is now resolved. Thank you for taking the time to update this thread with the outcome. More information on converting accounts to the Paper Lantern theme is available on the following thread: X3 is no more so need help in bulk Action Thanks!
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post