GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Small query on "GRANT STATEMENT"

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Small query on "GRANT STATEMENT"

    Hello,

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

    I am following this tutorial :-
    http://www.percona.com/doc/percona-xtrabackup/howtos/setting _up_replication.html under which it is said under POINT no. 3


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


    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

  • #2
    It is a new password that you can choose, and is later used in CHANGE MASTER TO on the slave.

    Comment


    • #3
      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

      Comment


      • #4
        gmose,

        Ok, still no affect, But got another error :-


        Slave_IO_Running: NoSlave_SQL_Running: Yes........ERROR:No query specified


        Can you PLEASE assist with this as well ?

        Thank you

        Comment


        • #5
          No issues, gmouse, I got my last issue resolved ,

          But my main concern is not yet resolved

          Comment

          Working...
          X