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.

"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,130
    Likes Received:
    3
    Trophy Points:
    38
    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?
     
  2. m4rc3

    m4rc3 Active Member

    Joined:
    Mar 26, 2010
    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    8
    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,557
    Likes Received:
    7
    Trophy Points:
    38
    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
     
  4. Julie-zhu

    Julie-zhu Registered

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

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

    ;);):cool:
     
  5. Julie-zhu

    Julie-zhu Registered

    Joined:
    Mar 26, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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?;);):):)
     
Loading...

Share This Page