Displaying 3 results from an estimated 3 matches for "jf_slave".
Did you mean:
vf_slave
2015 Mar 12
3
mysql replication - problems
...I'm having is that I can't seem to get the replication
user to connect. I had to use an account with more privileges (grant all)
in order to connect from the slave to the master.
I used this grant on the master to try and setup the replication user:
GRANT REPLICATION SLAVE ON *.* TO 'jf_slave'@'ops.somewhere.com' IDENTIFIED
BY 'secret' REQUIRE SSL;
Then back on the slave I used this command to connect the slave to the
master:
mysql> CHANGE MASTER TO MASTER_HOST='web2.somewhere.com',
MASTER_USER='jf_slave', MASTER_PASSWORD='secret',
MASTER...
2015 Mar 12
0
mysql replication - problems
...n't seem to get the replication
> user to connect. I had to use an account with more privileges (grant all)
> in order to connect from the slave to the master.
>
> I used this grant on the master to try and setup the replication user:
>
> GRANT REPLICATION SLAVE ON *.* TO 'jf_slave'@'ops.somewhere.com'
> IDENTIFIED
> BY 'secret' REQUIRE SSL;
>
> Then back on the slave I used this command to connect the slave to the
> master:
>
> mysql> CHANGE MASTER TO MASTER_HOST='web2.somewhere.com',
> MASTER_USER='jf_slave', MA...
2015 Mar 12
3
mysql replication - problems
...ation
> > user to connect. I had to use an account with more privileges (grant all)
> > in order to connect from the slave to the master.
> >
> > I used this grant on the master to try and setup the replication user:
> >
> > GRANT REPLICATION SLAVE ON *.* TO 'jf_slave'@'ops.somewhere.com'
> > IDENTIFIED
> > BY 'secret' REQUIRE SSL;
> >
> > Then back on the slave I used this command to connect the slave to the
> > master:
> >
> > mysql> CHANGE MASTER TO MASTER_HOST='web2.somewhere.com',
>...