Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Mar 2004
    Posts
    95

    Default cPanel remote mysql server [urgent]

    hi,

    i have done all the setup to make the remote mysql server:
    changed the /root/.my.cnf to the relative data
    updated the horde, phpMyAdmin, eximstats

    went to the WHM > SQL Services > Setup Remote MySQL server
    filled all everything change from sudo to su and inputed my root and procced

    it took a long time said few times timeout and at all said that it was complete but never worked at all.

    so i had to gather all the data from /var/lib/mysql and put it manually to the mysql server

    it is all working fine but i can't manage to WHM recognize it...

    what should i do in order to cPanel / WHM accept it ?

    the mysql server is setup on a 2nd machine at my internal lan. eth0 from both servers represente my internal lan and all the eth0 has no firewall or security.

    i am able to use the mysql server from both machines, and also from scripts and codes...

    just WHM and cPanel dont recognize it....

    also i am getting this every 5 minutes wich leads me to belive WHM is mad since it did not manage to acomplish the setup and has no mysql installed, i have turned of the warns in WHM but still getting it at /var/log/messages
    Aug 2 09:20:01 host lsb_log_message: MySQL PID file could not be found! failed
    Aug 2 09:20:36 host lsb_log_message: failed
    Last edited by prixone; 08-02-2007 at 08:21 AM.

  2. #2
    cPanel Development cpanelkenneth's Avatar
    Join Date
    Apr 2006
    Posts
    3,768
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    In your /root/.my.cnf file, the host entry points to the correct ipaddress/hostname ?

    You are using the default port for MySQL on the remote server?

    On your cPanel server, SSH into it (as root), and do the following:

    Code:
    # mysql -h remote_host -u root -p
    Replace remote_host with the actual IP Address or hostname that is assigned to the remote MySQL server.

    You verified MySQL is running on the remote server and the GRANT statements are all correct?

  3. #3
    Member
    Join Date
    Mar 2004
    Posts
    95

    Default

    the problem was that everything i hit the setup button it changed the .my.cnf i had already configured so once i did it all i came back and re-setup it and all seems fine so far ...
    thanks

Similar Threads & Tags
Similar threads

  1. How can I use remote mail server and mysql server with cpanel?
    By Seyhun in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 03-29-2011, 02:48 PM
  2. Remote MySQL server -- 1 DB server, many cPanel boxes
    By astopy in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 07-30-2010, 03:37 PM
  3. URGENT:remove remote mysql host???
    By aaronjw in forum cPanel and WHM Discussions
    Replies: 7
    Last Post: 12-02-2008, 10:55 AM
  4. Replies: 1
    Last Post: 09-17-2005, 01:32 AM
  5. Problems to configure remote mysql server in one server cpanel
    By deicox in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 04-15-2004, 07:48 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube