nothingless

Registered
May 14, 2011
4
0
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
 

nothingless

Registered
May 14, 2011
4
0
51
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
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,215
363
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.
 

nothingless

Registered
May 14, 2011
4
0
51
Code:
[email protected] [~]# 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
 

nothingless

Registered
May 14, 2011
4
0
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
 

smoge

Well-Known Member
Jul 2, 2004
52
0
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.