The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SOLVED Account restoration mysql username too long

Discussion in 'Database Discussions' started by MarkoTitel, Apr 17, 2017.

Tags:
  1. MarkoTitel

    MarkoTitel Member

    Joined:
    Nov 29, 2015
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Novi Sad
    cPanel Access Level:
    Root Administrator
    Hi,

    I have a fully working WHM server with backups setup and working.

    I have installed a TRIAL WHM licence on another server to test the backups just now.

    I am following simple restoration process:

    - Put the archive in the /root
    - Restore the account from WHM

    Issue I am facing is that I get a Warning message that MYSQL username is too long, and it was not created.

    Also when I check the database prefix on the new server, it is not the same as on the old one. It is shortened by few characters.

    Both WHM versions are the same. 64 (build 12).

    Anyone had these issues?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,086
    Likes Received:
    1,288
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Is "Require a username prefix on names of new databases and database users" enabled under the "SQL" tab in "WHM >> Tweak Settings" on this system? Also, could you let us know how long the account and database usernames are?

    Thank you.
     
  3. MarkoTitel

    MarkoTitel Member

    Joined:
    Nov 29, 2015
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Novi Sad
    cPanel Access Level:
    Root Administrator
    Hi, thanks for quick reply

    It is enabled on both servers. Both servers are same version.

    Database username is 19 characters long on the server that is in production.

    Cpanel username is 15 chars long.

    If char number is restricted how come on the working server I never got a warning and DB creation works fine.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,086
    Likes Received:
    1,288
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Documentation on this topic is available at:

    _MySQL Username Limit - Documentation - cPanel Documentation

    Here's a quote from this document:

    Is the server where the username was created using MariaDB? If so, you may want to upgrade the destination server to use MariaDB, as it allows for longer usernames:

    Thank you.
     
  5. MarkoTitel

    MarkoTitel Member

    Joined:
    Nov 29, 2015
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Novi Sad
    cPanel Access Level:
    Root Administrator
    Yes MysqlDB was instead of MariaDB.

    After I updated to MariaDB I had no problems.

    Thanks
     
    cPanelMichael likes this.
Loading...

Share This Page