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!

How to Setup Remote MySQL ?

Discussion in 'General Discussion' started by nothingless, May 15, 2011.

  1. nothingless

    nothingless Registered

    Joined:
    May 14, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    I have Server ONE current handle MySQL, I want use Server TWO handle all this MySQL and Server one only handle APACHE only. Both Server Install Cpanel (Centos). Anyone can tell me step by step to do this via WHM. Thank :D
     
    #1 nothingless, May 15, 2011
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    829
    Likes Received:
    26
    Trophy Points:
    178
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    In WHM, go to Setup Remote MySQL server - pretty self explanatory after that. It's listed step by step in the cPanel documentation:

    Setup Remote MySQL Server
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 vanessa, May 15, 2011
  3. nothingless

    nothingless Registered

    Joined:
    May 14, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    I read Document, and get this error. So how to resolve this ?

    Code:
        mysql started ok

Done
Testing new mysql setup...Failed to connect to the remote mysql host:

/usr/bin/mysqladmin: connect to server at '85.17.x.x failed
error: 'Can't connect to MySQL server on '85.17.154.x' (4)'
Check that mysqld is running on 85.17.x.x and that the port is 3306.
You can check this by doing 'telnet 85.17.x.x 3306'


Restoring old mysql config. Please resolve the above error and try again.
     
    #3 nothingless, May 15, 2011
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you run the "telnet" command from your server as listed in the error message and post the results here?

    Code:
    telnet 85.17.x.x 3306
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, May 16, 2011
  5. nothingless

    nothingless Registered

    Joined:
    May 14, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    Code:
    root@ServeronOne [~]# telnet 85.17.x.x 3306
Trying 85.17.x.x...
telnet: connect to address 85.17.x.x: Connection timed out
telnet: Unable to connect to remote host: Connection timed out
    Here is result via SSH telnet from ServerOne to ServerTwo
     
    #5 nothingless, May 16, 2011
  6. SoftDux

    SoftDux Well-Known Member

    Joined:
    May 27, 2006
    Messages:
    991
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Johannesburg, South Africa
    cPanel Access Level:
    Root Administrator
    Michael,

    Why does one need Telnet for remote MySQL? Surely this is VERY insecure?
     
    #6 SoftDux, May 16, 2011
  7. nothingless

    nothingless Registered

    Joined:
    May 14, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    I resolved this 3306, cause by ServerOne install CSF and not open port TCP OUT 3306. BUt a problem arise:
    - I can't backup my db on ServerOne ( I used to backup succesfully with this, but after using remote , It's stop)

    Code:
    mysqldump: Got error: 1044: Access denied for user 'megxxx_for'@'66.x.x.x' to database 'megxxx_for' when selecting the database
    note: 66.x.x.x is ip ServerOne
     
    #7 nothingless, May 16, 2011
  8. smoge

    smoge Well-Known Member

    Joined:
    Jul 2, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    156
    After switching to using remote SQL, the db connection will not work until you go to cpanel for that domain, and visit the mySQL page in cPanel... just load this page in your browser.

    I dont know if it is a bug, or by design - but I can say that you need to do this for each cpanel account, if you expect the db connection (username and password) to work.
     
    #8 smoge, May 23, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Setup Remote MySQL
  1. Spuddyboy

    SOLVED Setup Remote MySQL - WHM 68

    Spuddyboy, Apr 16, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    130
    cPanelMichael
    Apr 17, 2018
  2. postcd

    How to setup remote mysql server to decrease RAM usage on source server?

    postcd, Jul 12, 2016, in forum: Database Discussion
    Replies:
    1
    Views:
    2,552
    cPanelMichael
    Jul 13, 2016
  3. Costas Lazarou

    SOLVED Private Name Servers setup

    Costas Lazarou, Jun 21, 2018 at 5:03 AM, in forum: Bind/DNS/Nameserver
    Replies:
    3
    Views:
    50
    Costas Lazarou
    Jun 22, 2018 at 1:45 AM
  4. SactoBob

    Cluster setup to sync to outside DNS

    SactoBob, Jun 14, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    4
    Views:
    63
    cPanelLauren
    Jun 15, 2018
  5. Uriel Castillo

    SOLVED Clam AV setup does not place link in cPanel

    Uriel Castillo, Jun 4, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    47
    cPanelMichael
    Jun 4, 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