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 MySQL configuration

Discussion in 'General Discussion' started by JamesSmith, Apr 19, 2005.

  1. JamesSmith

    JamesSmith Well-Known Member

    Sep 17, 2003
    Likes Received:
    Trophy Points:
    UK, Luton
    Hi - We're looking to setup a remote MySQL server, we have the machine purchased and ready to go. We intended to setup multiple processes of MySQL on different hosts / IPs for each of our web boxes on the MySQL server. This we have done.

    The problem we now face is configuring the cPanel web boxes to use the remote server.

    It seems the way cPanel has this implemented, the web server wants to "take over" the remote MySQL host, asking for the root password (not just mysql root), installing cPanel scripts and so on, on the remote MySQL server. This is not ideal, as we want to run multiple MySQL processes on the MySQL server to avoid any database name and username conflicts across our web boxes.

    Is there anyway at all this can be achieved, avoiding the way cPanel wants to do it and simply connect to the MySQL server? We need to get something sorted for this, if nothing can be done with remote MySQL the way we want it, we’re going to need to re-think our strategy of expanding our current capacity. The whole idea was to move MySQL off onto this new powerful remote server, reducing load and increasing performance across the board on our web boxes.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. dave9000

    dave9000 Well-Known Member

    Apr 7, 2003
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    I logged a enhancement in bugzilla for something close to what your wanting a while back. What we need is people voting for it and cpanel will add it

    It would probably solve the issues your talking about
    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