Are you simply attempting to setup a remote MySQL server for use by the cPanel/WHM server or are you having a specific set of scripts on the cPanel/WHM server connect to a remote MySQL server?
setup remote mysql server to use with cpanel/whm. on a LAMP server everything include Cpanel is install on 1 box, now i want to use a seperate server for mysql, and want to know how to set it up so cpanel will work with the external mysql server.
setup remote mysql server to use with cpanel/whm. on a LAMP server everything include Cpanel is install on 1 box, now i want to use a seperate server for mysql, and want to know how to set it up so cpanel will work with the external mysql server.
Actually, that's fairly easy as long as you follow the instructions provided in the WHM interface.
Go to WHM -> SQL Services -> Setup Remote MySQL Server. At the bottom of that page you will see some notes:
* You must be able to connect via ssh from this server's IP address for this to work properly.
* MySQL and Perl must already be installed on the remote server.
First of all both servers will reside on the same private lan communication between web and database server will only be on private lan for speed and bw. So do i need SSH ?
form fresh the web server will have apache, php and cpanel installed (no mysql) the db server have mysql install up and running.
Now all i do is go into WHM -> SQL Services -> Setup Remote MySQL Server follow instruction on screen and that's it ? I will have a complete LAMP setup ?
First of all both servers will reside on the same private lan communication between web and database server will only be on private lan for speed and bw. So do i need SSH ?
SSH is simply the means by which this process is done, it has nothing to do with the proximity of the servers therefore, yes, the cPanel/WHM server will need to be able to SSH to the MySQL server. How you set that up is essentially up to you.
form fresh the web server will have apache, php and cpanel installed (no mysql) the db server have mysql install up and running.
Now all i do is go into WHM -> SQL Services -> Setup Remote MySQL Server follow instruction on screen and that's it ? I will have a complete LAMP setup ?