The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

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

  1. rasa

    rasa Active Member

    Joined:
    Feb 17, 2013
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello
    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
    command
    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 ?


    Thanks
     
  2. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    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:

    https://documentation.cpanel.net/display/ALD/Setup+Remote+MySQL+Server

    This should resolve your issues and you won't have to turn off local MySQL server as well.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,828
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page