dbaxt

Member
Jun 30, 2011
5
0
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:

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
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?
 

MikeDVB

Well-Known Member
PartnerNOC
Jun 4, 2008
218
3
68
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.