Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Database Replication

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

  1. dbaxt

    dbaxt Member

    Joined:
    Jun 30, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    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:
    68
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice