I'm having difficulty connecting MySQL slave database to master using MyWorkBench.
CREATE USER 'replication'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON . TO 'replication'@localhost' WITH GRANT OPTION;
using IP address instead of the server name
I confirmed that:
I followed all the steps for setting server_id for slave and master
I could ping both master and slave servers
Can anyone help me with this, please?