In your /root/.my.cnf file, the host entry points to the correct ipaddress/hostname ?
You are using the default port for MySQL on the remote server?
On your cPanel server, SSH into it (as root), and do the following:
Code:
# mysql -h remote_host -u root -p
Replace
remote_host with the actual IP Address or hostname that is assigned to the remote MySQL server.
You verified MySQL is running on the remote server and the GRANT statements are all correct?