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!

Remote DB (mariaDB) Server, PHPMyAdmin and cpanel OFFLINE message

Discussion in 'Database Discussion' started by rasa, Jun 26, 2015.

  1. rasa

    rasa Active Member

    Feb 17, 2013
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    ive installed a new server and make proper changes to connect cpanel to remote database server ( Centos 7 with MariaDB as database server) and every thing seems to be OK !
    but after ive transferred accounts from old server i have some problems
    ( almost all databases migrated to new database server without any error )
    but now
    1 - in cpanel on users account when i click on mysql databases it show a red
    The mysql server is offline.meesage
    also in phpmyadmin of cpanel users account i get The mysql server is offline. too
    also at first i had a You must upgrade to mysql 5.0.13 message on PHPmyadmin for users but phpmyadmin from WHM lunched without problem

    this is happening when i tried to stop local mysql server on cpanel server with
    service mysql stop
    also chkconfig mysql off
    but it will get started after a few minutes automatically

    even when i stop local database server all sites have no problem as they must be ,because they are connected to remote server without problem

    my question is how to solve those offline messages
    and is it necessary to stop local mysql server and how could i prevent it from auto start after a few minutes ?

  2. 24x7ss

    24x7ss Well-Known Member

    Sep 30, 2014
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

    It seems you have not enabled Remote Mysql Server in cPanel settings and therefore PHPMyAdmin/cPanel is connecting to local and showing these error messages. You can follow below documentation for the same:

    This should resolve your issues and you won't have to turn off local MySQL server as well.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you verify if you followed all of the steps listed in the document referenced in the previous post?

    Thank you.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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.
    Dismiss Notice