MySQL Tidbits

Allow Slave to connect master:

C:\mysql>create user 'replica'@'' identified by '<YOUR PASSWORD>';

NOTE: which is the SLAVE machine‟s address.

i. mysql>grant create,insert,select,update,delete on ejbca.* to 'replica'@'';

Checking if Slave can connect to Master:

C:\>mysql –u replica –h –p

C:\>Enter password: <YOUR VALUES>

NOTE: If the mysql prompt opens then the Master machine can be accessed from the Slave machine.




Leave a Reply