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 5.x

Discussion in 'General Discussion' started by typhon, Jan 15, 2006.

  1. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    Has anyone attempted to do an RPM update for MySQL from 4.1 to 5.x yet?

    I am sure someone on here has, maybe tell us what you did? I was thinking about doing so and removing all the old rpms and doing a new intall with 5.x now. I am getting sick of the wait times before getting items like this and since it is third party it is not the main focus. So yep. I might attempt to do this later although all I have is my production box.
     
    #1 typhon, Jan 15, 2006
  2. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Sydney, Australia
    cPanel Access Level:
    DataCenter Provider
    I would dump all the databases etc. uninstall the 4.1 rpms, remove the mysql data directory, install 5.0 fresh and then reload the databases etc back.

    Regards,
    Alan
     
    #2 Sinewy, Jan 15, 2006
  3. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    cool. this upgrade worked like a charm... it seems that the mysql functions in WHM work as well. Then I downloaded and updated phpmyadmin so we are all set to go here :)

    "Welcome to phpMyAdmin 2.7.0-pl2
    MySQL 5.0.18-standard running on localhost"

    Here was the steps...

    rpm -e all of the old mysql rpms
    rpm -i all of the 5.0 rpms

    service mysql restart
    /usr/bin/mysql_fix_privilege_tables --password=yourpasswordhere

    cd /usr/local/cpanel/base/3rdparty
    wget http://easynews.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.7.0-pl2.zip
    unzip phpMyAdmin-2*
    rm phpMyAdmin-2*.zip
    chown root:wheel phpMyAdmin-2*
    chmod 0700 phpMyAdmin-2*
    cd phpMyAdmin-2*
    chown -R cpanel:cpanel *
    chmod -R 0700 *
    cp ../phpMyAdmin/config.inc.php
    cd ../
    mv phpMyAdmin phpMyAdmin-bak
    mv phpMyAdmin-2* phpMyAdmin

    now you should be all set to go :)
     
    #3 typhon, Jan 15, 2006
  4. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    One note I should add onto this...
    When you install the rpms for client and server make sure to use the flag --nodeps otherwise it will complain about perl-DBI not being installed. When I checked through cpan DBI was infact installed just not through an RPM. So keep that in mind :)
     
    #4 typhon, Jan 15, 2006
  5. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,470
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    Don't forget to do the following or cPanel updates will wipe out all your hard work:

    touch /etc/mysqlupdisable
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 chirpy, Jan 15, 2006
  6. b0072k1

    b0072k1 Well-Known Member

    Joined:
    Dec 30, 2004
    Messages:
    132
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Glasgow
    any one o fgettin the new phpmyadmin running on 4.1?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 b0072k1, Mar 20, 2006
  7. [MuTe]

    [MuTe] Member

    Joined:
    Oct 4, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    151
    Thx This Worked

    This worked for me too.

    Thx for posting it :D
     
    #7 [MuTe], Mar 21, 2006
  8. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    8
    Trophy Points:
    193
    I would be more interested in user compatibility problem to be reported with MySQL 5.

    We have not upgraded to MySQL 5 yet because we have had a large number of
    users tell us that their scripts and programs are not compatible with MySQL 5.

    (The largest group of complainers are coming from those running IPB forum software)

    So for those who have gone to MySQL 5, are you getting any user complaints
    coming back at you regarding any software incompatibilities?
     
    #8 Spiral, Mar 25, 2006
  9. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    Yes, we upgraded MySQL to one of our clients to v5.0.19-0 and VB behaved weird, so we had to downgrade to v4.1.18.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 AndyReed, Mar 25, 2006
  10. NetBlaster

    NetBlaster Member

    Joined:
    Jun 12, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    151
    #10 NetBlaster, Mar 26, 2006
  11. Bulent Tekcan

    Bulent Tekcan Well-Known Member

    Joined:
    May 11, 2004
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    166
    After upgrade I have received this error...

    Warning: Default theme green_orange not found! in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/Theme_Manager.class.php on line 57


    Any idea ?
     
    #11 Bulent Tekcan, Apr 30, 2006
  12. NetBlaster

    NetBlaster Member

    Joined:
    Jun 12, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    151

    Edit this file: /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

    Find the line with green_orange and change it to darkblue_orange.

    You can add different theme from phpmyadmins site.
     
    #12 NetBlaster, Apr 30, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL
  1. RobNH

    MySQLi - Too Many Connections Error due to Amazon AWS

    RobNH, Jun 21, 2018 at 7:47 AM, in forum: Database Discussion
    Replies:
    5
    Views:
    40
    Infopro
    Jun 21, 2018 at 10:03 AM
  2. geekbaaz

    Multiple cPanel servers with a common MySQL server?

    geekbaaz, Jun 21, 2018 at 3:24 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    54
    cPanelMichael
    Jun 21, 2018 at 11:32 AM
  3. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018 at 11:46 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    46
    cPanelMichael
    Jun 21, 2018 at 10:31 AM
  4. tyuuu

    mysql_pconnect can not work after change password/username

    tyuuu, Jun 19, 2018 at 9:14 AM, in forum: Database Discussion
    Replies:
    10
    Views:
    62
    cPanelLauren
    Jun 20, 2018 at 9:38 AM
  5. Skin

    Migration from VPS with MySQL 5.6 to a VPS with MySQL 5.7

    Skin, Jun 18, 2018 at 11:04 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    35
    Skin
    Jun 19, 2018 at 12:09 PM

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.
    Accept Learn More...
    Dismiss Notice