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:
    45,774
    Likes Received:
    1,995
    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:
    45,774
    Likes Received:
    1,995
    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:
    117
    Likes Received:
    10
    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. maestroc

    sqlite and pdo_mysql errors after Apache 4 upgrade

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

    Error in MySQL upgrade from 5.6 to 5.7

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

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    609
    cPanelMichael
    Jun 21, 2018
  4. greektranslator

    Upgrade MariaDB to 10.3: backup without mysqldump?

    greektranslator, Jan 16, 2019, in forum: Database Discussion
    Replies:
    3
    Views:
    139
    cPanelMichael
    Jan 21, 2019 at 1:22 PM
  5. 34ever

    Upgraded to MySQL 8.0 issue

    34ever, Dec 14, 2018, in forum: EasyApache
    Replies:
    5
    Views:
    384
    cPanelMichael
    Dec 20, 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