Mysql database replication

The phpMyAdmin that is bundled with cPanel doesn’t include user management so the following commands needed to be run to give the replication user the correct permissions:

Setting up the Master , add the slave replication user. The IP below is the slave IP.

mysql -e “GRANT REPLICATION CLIENT ON *.* TO ‘user_replicate’@’’;”
mysql -e “GRANT REPLICATION SLAVE ON *.* TO ‘user_replicate’@’’;

You should now be able to add the user user_replicate under Replication in phpMyAdmin.