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.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.