Database Replication

dbaxt

• November 23, 2013 14:36

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: [QUOTE] Edit Privileges: User 'replicationuser'@'' - Database The selected user was not found in the privilege table.
I can't find the privilege table, not do I have a privileges tab in PHPMYADMIN when logged in as root. /etc/my.cnf [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?

• 

  MikeDVB

  • November 25, 2013 02:35

  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.

  0

Please sign in to leave a comment.