The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database Replication

Discussion in 'Database Discussions' started by dbaxt, Nov 23, 2013.

  1. dbaxt

    dbaxt Member

    Joined:
    Jun 30, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi!
    I am trying to setup Replication between my cPanel server and another Linux server but I've ran into a few problems.

    When I try and create a replication user, I get the following:

    I can't find the privilege table, not do I have a privileges tab in PHPMYADMIN when logged in as root.


    /etc/my.cnf
    Code:
    [mysqld]
    innodb_file_per_table=1
    open_files_limit=27882
    server-id=5004425
    log_bin=mysql-bin
    log_error=mysql-bin.err
    binlog_do_db=DBNAME
    old-passwords=1
    
    Does anyone have any suggestions, please?
     
  2. MikeDVB

    MikeDVB Well-Known Member
    PartnerNOC

    Joined:
    Jun 4, 2008
    Messages:
    212
    Likes Received:
    3
    Trophy Points:
    18
    Location:
    Indiana, USA
    Where is 'replicationuser' - on the server you're trying to replicate to or from?

    That said - for this sort of work I'd likely work via the MySQL CLI instead of using a GUI tool like phpMyAdmin myself.
     
Loading...

Share This Page