Not the answer you need?
Register and ask your own question!

Small query on "GRANT STATEMENT"

systemalisystemali AdvisorCurrent User Role Beginner

Can some one care to clear one doubt for me on setting up replication.

I am following this tutorial :- _up_replication.html under which it is said under POINT no. 3

TheMaster|mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'$slaveip' IDENTIFIED BY '$slavepass';</pre>

I need to know what slave password is it referring to ?

Is it the Mysql Password or the ROOT server password that we must use ?

Please assist !!

Thank you


  • gmousegmouse Mod Squad Inactive User Role Beginner
    It is a new password that you can choose, and is later used in CHANGE MASTER TO on the slave.
  • systemalisystemali Advisor Current User Role Beginner
    Thank you so very much 'gmouse', Highly appreciate your assistance.

    I shall give it a try.

    I would also appreciate if you could refer to another query of mine in another thread titled :-

    "Slave_SQL_Running: No"

    Thank you
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.