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 upgrade error version 5.1 to 5.5 (500 Iternal server error)

Discussion in 'Database Discussion' started by promesashost, Jun 19, 2014.

  1. promesashost

    promesashost Registered

    Joined:
    Jun 19, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I have a problem with my server just upgraded mysql from version 5.1 to version 5.5 and is giving me 500 error internal error I need urgent help thanks
     
    #1 promesashost, Jun 19, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    What method did you use to upgrade to MySQL 5.5? Did you ensure PHP was rebuilt using EasyApache during the process? What's the output in /usr/local/apache/logs/error_log when this error occurs?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jun 20, 2014
  3. shufil

    shufil Well-Known Member

    Joined:
    Mar 19, 2014
    Messages:
    71
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello Team,

    sorry here

    I need also upgrade from mysql 5.1 to 5.5 , so whitch methode we can use here , also we need to up all php libs with mysql5.5 and related pakeges .
    so please advice .

    Regards,
    Shufil
     
    #3 shufil, Jun 24, 2014
  4. EThSupport24

    EThSupport24 Registered

    Joined:
    Jun 21, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    Upgrade Mysql through WHM , Home » Software » MySQL Upgrade and follow the instructions. At the end you will see option for PHP compilation that is EasyApche just select it and proceed with the upgrade.

    If you still facing same errors, run /scripts/easyapache on the shell.

    Thanks,

    EthSupport
     
    #4 EThSupport24, Jun 24, 2014
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Yes, it's advised to upgrade MySQL directly through Web Host Manager:

    "WHM Home » Software » MySQL Upgrade"

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, Jun 24, 2014
  6. shufil

    shufil Well-Known Member

    Joined:
    Mar 19, 2014
    Messages:
    71
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,

    Thanks , Thanks for support , :) .

    may be its not happen , by chance If my new mysql vertion not support current DB, so what we do that situvation .

    Regards,
    Shufil
     
    #6 shufil, Jun 25, 2014
  7. SS-Maddy

    SS-Maddy Well-Known Member

    Joined:
    Mar 28, 2009
    Messages:
    83
    Likes Received:
    1
    Trophy Points:
    56
    cPanel Access Level:
    Root Administrator
    The "500 Iternal server Error" is webserver error and checking the apache logs will be more helpful. MySQL version change won't affect the functionality of existing DBs. The issue looks to be related with php mysql extension. Please make a php recompile with updated mysql extension and check. You may check mysql log file for any possible db issues through /var/lib/mysql/server_name.err
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 SS-Maddy, Jun 25, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysql upgrade error
  1. 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
  2. MyDreamscape

    Error MySQL/MariaDB Upgrade (5.6 to 10.0) step 4

    MyDreamscape, Sep 29, 2016, in forum: Database Discussion
    Replies:
    4
    Views:
    1,692
    cPanelMichael
    Oct 6, 2016
  3. Edwin Tjallings

    In Progress [CloudLinux ALTPHP-524] Alt-php not working after mysql 5.7 upgrade

    Edwin Tjallings, Jun 13, 2018, in forum: CloudLinux
    Replies:
    5
    Views:
    172
    cPanelMichael
    Jun 19, 2018 at 8:11 AM
  4. Nirjonadda

    MySQL 5.7 upgrade process failed

    Nirjonadda, Feb 6, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    562
    cPanelMichael
    Feb 14, 2018
  5. psytanium

    SOLVED MySQL upgrade recommendation

    psytanium, Jan 17, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    720
    PeteS
    Feb 7, 2018

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