need help with How To Set Up Database Replication In MySQL

Discussion in 'Server Operation' started by cruz, Sep 15, 2007.

  1. cruz

    cruz New Member

    Things went well until I got here.
    HTML:
    mysqldump -u root -p<password> --opt exampledb > exampledb.sql 
    After I entered this command, I got this back
    HTML:
    No such file or directory
    
    I changed the info to what it told me. Help
    Was I suppose to enter the user name (web4_u1) were slave_user is?
    GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY '<some_password>'; (Replace <some_password> with a real password!)

    If so, you might want to add that into the directions for people like me. :)
     
    Last edited: Sep 15, 2007
  2. falko

    falko Super Moderator Howtoforge Staff

  3. cruz

    cruz New Member

    did not work

    I tried the link you sent me. It comes back with this error
    HTML:
    Got error: 1045: Access denied for user '[root]'@'localhost' (using p                      assword: YES) when trying to connect
    
    I was trying to setup the 2ND server to upload the dump from the
    1ST server again and got the same errors as I entered at the top of this message. I can login to the database in the ispconfig. It is the database password I am suppose to enter right? not the root password, And this is done on the root server right? I am frustrated::confused:
     
  4. falko

    falko Super Moderator Howtoforge Staff

    Why does it say [root] instead of root?

    Does
    Code:
    mysql -h localhost -u root -p
    work?
     
  5. cruz

    cruz New Member

    new

    I told you I was green Thanks. I'll get there. With your help.:)
     

Share This Page