Database Replication

[dbaxt]

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:

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]

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.