Scott,
Secondly, when i issue “grant” statement on the MASTER server :-
TheMaster|mysql> GRANT REPLICATION SLAVE ON . TO ‘root’@’$slaveip’ IDENTIFIED BY ‘$slavepass’;
and then run the ‘show grants’ command on the MASTER, I DO NOT SEE the grants issues above, :-
What i see is :-
mysql> show grants;
±---------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
±---------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON . TO ‘root’@‘localhost’ IDENTIFIED BY PASSWORD ‘*B54DAEC9554BF364E94BE34320BB868A24446646’ WITH GRANT OPTION |
| GRANT PROXY ON ‘’@’’ TO ‘root’@‘localhost’ WITH GRANT OPTION |
±---------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
What could be the reason for this ?
Thank you