Installing whm/cpanel and Using a Remote MySQL Server

Got a task: install WHM/cPanel on a server. Sounds simple enough, except there are two servers involved:
1 - web server.
2 - MySQL database server.

So let’s get started. First download the WHM installer and run it:

wget -N http://httpupdate.cpanel.net/latest
sh latest

Numbers and letters start scrolling across the screen. The installer will pull in, install and configure all the necessary packages. By default Apache 2.2 and PHP 5.4 get installed. After installation you can change this in the panel itself (the EasyApache section).

During installation it’ll complain about a pre-installed Mysql server, but if apache was already installed on your server - the installer will happily wipe it out.

Once installation finishes, the script prints info on how to log in to the panel. By default it’s available over HTTPS on port 2087. That is:
https://<your_ip_address>:2087

Log in with the username root and the password.

Next go to the SQL Services section and pick Setup Remote MySQL Server

In the Remote server address (IP address or FQDN): field, enter the ip address of the remote mysql server.

Pick the authorization type. Then generate a key or enter the root password for the database server. Click Save. Done.

During the process I got this message:

The eximstats transfer cannot continue. The transfer will have to be done manualy.

I happily ignored it, since there was nothing to transfer - clean server.