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!

"Old style passwords" settings when using MySQL 5.x

Discussion in 'General Discussion' started by Kent Brockman, Mar 8, 2010.

  1. Kent Brockman

    Kent Brockman Well-Known Member

    Joined:
    Jan 20, 2008
    Messages:
    1,187
    Likes Received:
    8
    Trophy Points:
    168
    Location:
    Buenos Aires, Argentina
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi there, I'm wondering if after upgrade to MySQL 5.1 I have to manually deactivate the Tweak Settings option "Use old style (4.0) passwords with MySQL® 4.1+" or it will automatically be hidden when running on MySQL 5.x
    Can anybody confirm?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. m4rc3

    m4rc3 Active Member

    Joined:
    Mar 26, 2010
    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    58
    Old style password is used when mysql5 is installed and you have old passwords from mysql4.
    Using old style passwords under mysql4 is pointless

    If you upgraded from mysql4 to mysql5 then you should enable that option.

    Cpanel will not enable it or disable it on it's own based on upgrades or downgrades.
     
    #2 m4rc3, Mar 26, 2010
    Last edited: Mar 26, 2010
  3. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    The option will still be available in on the WHM Tweak Settings page after performing a MySQL upgrade; if the purpose of the option is no longer desired it may be disabled. In reference to the version number, the plus sign ("+") was used to indicate that it includes MySQL versions 4.1 and later, including both 5.0 and 5.1.

    Reference menu path:
    WHM: Main >> Server Configuration >> Tweak Settings >> SQL
    • Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)

    Reference MySQL documentation:
    MySQL :: MySQL 5.1 Reference Manual :: 5.3.2.3 Password Hashing in MySQL
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Julie-zhu

    Julie-zhu Registered

    Joined:
    Mar 26, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    WOW!
    That's great!

    :) Hey everybody, im new here, nice to meet you!

    ;);):cool:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Julie-zhu

    Julie-zhu Registered

    Joined:
    Mar 26, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    I'm sorry i don't understand what you are talkong about.
    Anyway, glad to see you, i think ill know it sooner or later.
    What do you think?;);):):)
     
    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