How is "Setup Remote MySQL server" in Cpanel used
Say I have a server (that handles web and mysql). I'd like to separate to 2 servers (1 handle web, the other handle mysql). So what I have to do is to copy the mysql databases to a new server, then change the settings in "Setup Remote MySQL server" in cpanel. Whenever a script on the webserver calls the database, a connection is automatically made to the mysql server. No changes is needed on the scripts on the web server to point to new database server. Is that how the function is used? Thank you.
