MySQL Tidbits

Allow Slave to connect master:

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

NOTE: 192.168.0.110 which is the SLAVE machine‟s address.

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

Checking if Slave can connect to Master:

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

C:\>Enter password: <YOUR VALUES>

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