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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,161
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,331
    Likes Received:
    2,161
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:
    122
    Likes Received:
    13
    Trophy Points:
    68
    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. aries

    Error in MySQL upgrade from 5.6 to 5.7

    aries, Feb 22, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    593
    cPanelMichael
    Feb 25, 2019
  2. maestroc

    sqlite and pdo_mysql errors after Apache 4 upgrade

    maestroc, Oct 3, 2018, in forum: EasyApache
    Replies:
    1
    Views:
    290
    cPanelLauren
    Oct 8, 2018
  3. ejde

    Error in MySQL upgrade from 5.6 to 5.7

    ejde, Aug 27, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    1,306
    cPanelMichael
    Aug 28, 2018
  4. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    938
    cPanelMichael
    Jun 21, 2018
  5. renatoandrade

    New Thread Upgrade to MySQL 5.7 Failed

    renatoandrade, Jun 24, 2019 at 9:25 PM, in forum: Database Discussion
    Replies:
    0
    Views:
    73
    renatoandrade
    Jun 24, 2019 at 9:25 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