1) Install mysql
2) Run mysql_install_db
3) On the cPanel Server - cat /root/.my.cnf - get the password
4) On the Database Server :
#/usr/bin/mysqladmin -u root password 'PASSWORD FROM 3 HERE'
5) create /root/my.cnf
6) Set password for all root users:
mysql> UPDATE mysql.user SET Password='PASSWORD FROM 3 HERE' WHERE User='root';
7) Create a user for cpanel server
mysql> CREATE USER 'root'@'host' IDENTIFIED BY PASSWORD ' PASSWORD FROM 3 HERE';
8) GRANT SUPER on last user created
mysql> GRANT SUPER ON *.* TO 'root'@'host';
9) GRANT all privileges
mysql> GRANT ALL PRIVILEGES ON *.* to 'root'@'host';
10) add hostname for cpanel server to /etc/hosts