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 root password special characters

Discussion in 'Database Discussion' started by MajorLancelot, Jan 21, 2019.

  1. MajorLancelot

    MajorLancelot Well-Known Member

    Joined:
    Dec 17, 2014
    Messages:
    47
    Likes Received:
    4
    Trophy Points:
    83
    Location:
    Shinjuku-ku, Tokyo, Japan
    cPanel Access Level:
    Root Administrator
    At this page: MySQL Root Password - Version 74 Documentation - cPanel Documentation, cPanel clearly stated:

    Now customers often us the Password Generator to generate passwords.

    They also use MySQL Database Wizard to create databases where they are presented with the aforementioned Password Generator.

    For MySQL databases, to meet the minimum conditions required for a strong password, the password must contain at least:

    • Nine characters
    • Two uppercase letters
    • Two lowercase letters
    • Two numbers
    • Two of the following allowed special characters:

    Code:
      ‘ ~ ! @ # $ % ^ & * ( ) _ - + = { } [ ] / < > , . ; ? ' : | (space)
    There doesn't seem to be any restrictions on the length of a password or characters MYSQL supported especially since MySQL validate_password plugin.

    What is cPanel official position on this?

    Do we ask customers not to use special characters too and use only longer passwords?

    If the above is affirmative, shouldn't cPanel has a tool-tip that inform cPanel users of this?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,466
    Likes Received:
    505
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. MajorLancelot

    MajorLancelot Well-Known Member

    Joined:
    Dec 17, 2014
    Messages:
    47
    Likes Received:
    4
    Trophy Points:
    83
    Location:
    Shinjuku-ku, Tokyo, Japan
    cPanel Access Level:
    Root Administrator

    Thanks, Lauren!

    But is the operative word here "relevant" (instead of "valid") for the root MySQL user?

    Just need to understand why the rationale behind this decision and why it will be relevant to the root user, and not a cPanel user.

    Thanks!
     
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,466
    Likes Received:
    505
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    I believe this was a caveat of the way we use PHPMyAdmin with WHM/cPanel. As to why it's different for root user as opposed to the account level user I am assuming the root user has different privileges it can access and maintain all of the accounts users and databases.
     
    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