Slave Connection 1130





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







0















So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following:



+------------------+----------+---------------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+---------------------+------------------+-------------------+
| mysql-bin.000001 | 713473 | some_database | | |
+------------------+----------+---------------------+------------------+-------------------+


Then on my slave (which is actually MAMP PRO) I connect it to the master via the following:



CHANGE MASTER TO MASTER_HOST='xxx.xxx.xxx.xx', MASTER_USER='my_slave', MASTER_PASSWORD='my_slave_password!', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=713473;


And when I look at the log from MAMP PRO, I get the following:



170529  2:14:00 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='xxx.xxx.xxx.xx', master_port='3306', master_log_file='mysql-bin.000001', master_log_pos='713473'.
170529 2:14:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 713473, relay log './mysql-relay-bin.000001' position: 4
170529 2:14:42 [ERROR] Slave I/O: error connecting to master 'my_slave@xxx.xxx.xxx.xx:3306' - retry-time: 60 retries: 86400, Error_code: 1130


Before trying this method, I tried editing the my.cnf file for MAMP PRO and it didn't work. Since then, I deleted the master.info, which was empty anyways, and tried this method. What else can I try? The log doesn't seem to give me any actual information, is there anywhere else I can look for info?










share|improve this question














bumped to the homepage by Community 5 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.






















    0















    So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following:



    +------------------+----------+---------------------+------------------+-------------------+
    | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
    +------------------+----------+---------------------+------------------+-------------------+
    | mysql-bin.000001 | 713473 | some_database | | |
    +------------------+----------+---------------------+------------------+-------------------+


    Then on my slave (which is actually MAMP PRO) I connect it to the master via the following:



    CHANGE MASTER TO MASTER_HOST='xxx.xxx.xxx.xx', MASTER_USER='my_slave', MASTER_PASSWORD='my_slave_password!', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=713473;


    And when I look at the log from MAMP PRO, I get the following:



    170529  2:14:00 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='xxx.xxx.xxx.xx', master_port='3306', master_log_file='mysql-bin.000001', master_log_pos='713473'.
    170529 2:14:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 713473, relay log './mysql-relay-bin.000001' position: 4
    170529 2:14:42 [ERROR] Slave I/O: error connecting to master 'my_slave@xxx.xxx.xxx.xx:3306' - retry-time: 60 retries: 86400, Error_code: 1130


    Before trying this method, I tried editing the my.cnf file for MAMP PRO and it didn't work. Since then, I deleted the master.info, which was empty anyways, and tried this method. What else can I try? The log doesn't seem to give me any actual information, is there anywhere else I can look for info?










    share|improve this question














    bumped to the homepage by Community 5 mins ago


    This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.


















      0












      0








      0








      So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following:



      +------------------+----------+---------------------+------------------+-------------------+
      | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
      +------------------+----------+---------------------+------------------+-------------------+
      | mysql-bin.000001 | 713473 | some_database | | |
      +------------------+----------+---------------------+------------------+-------------------+


      Then on my slave (which is actually MAMP PRO) I connect it to the master via the following:



      CHANGE MASTER TO MASTER_HOST='xxx.xxx.xxx.xx', MASTER_USER='my_slave', MASTER_PASSWORD='my_slave_password!', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=713473;


      And when I look at the log from MAMP PRO, I get the following:



      170529  2:14:00 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='xxx.xxx.xxx.xx', master_port='3306', master_log_file='mysql-bin.000001', master_log_pos='713473'.
      170529 2:14:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 713473, relay log './mysql-relay-bin.000001' position: 4
      170529 2:14:42 [ERROR] Slave I/O: error connecting to master 'my_slave@xxx.xxx.xxx.xx:3306' - retry-time: 60 retries: 86400, Error_code: 1130


      Before trying this method, I tried editing the my.cnf file for MAMP PRO and it didn't work. Since then, I deleted the master.info, which was empty anyways, and tried this method. What else can I try? The log doesn't seem to give me any actual information, is there anywhere else I can look for info?










      share|improve this question














      So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following:



      +------------------+----------+---------------------+------------------+-------------------+
      | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
      +------------------+----------+---------------------+------------------+-------------------+
      | mysql-bin.000001 | 713473 | some_database | | |
      +------------------+----------+---------------------+------------------+-------------------+


      Then on my slave (which is actually MAMP PRO) I connect it to the master via the following:



      CHANGE MASTER TO MASTER_HOST='xxx.xxx.xxx.xx', MASTER_USER='my_slave', MASTER_PASSWORD='my_slave_password!', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=713473;


      And when I look at the log from MAMP PRO, I get the following:



      170529  2:14:00 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='xxx.xxx.xxx.xx', master_port='3306', master_log_file='mysql-bin.000001', master_log_pos='713473'.
      170529 2:14:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 713473, relay log './mysql-relay-bin.000001' position: 4
      170529 2:14:42 [ERROR] Slave I/O: error connecting to master 'my_slave@xxx.xxx.xxx.xx:3306' - retry-time: 60 retries: 86400, Error_code: 1130


      Before trying this method, I tried editing the my.cnf file for MAMP PRO and it didn't work. Since then, I deleted the master.info, which was empty anyways, and tried this method. What else can I try? The log doesn't seem to give me any actual information, is there anywhere else I can look for info?







      mysql replication my.cnf centos deployment






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked May 29 '17 at 0:26









      David RhoderickDavid Rhoderick

      1




      1





      bumped to the homepage by Community 5 mins ago


      This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







      bumped to the homepage by Community 5 mins ago


      This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
























          1 Answer
          1






          active

          oldest

          votes


















          0














          first of all You need to test connection from slave to master
          You can do this from command line (CMD windows)



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password!


          if it will be successful You will have normal mysql console



          Welcome to the MySQL monitor.  Commands end with ; or g.
          Your MySQL connection id is 29
          Server version: 5.7.15 MySQL Community Server (GPL)

          Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

          Oracle is a registered trademark of Oracle Corporation and/or its
          affiliates. Other names may be trademarks of their respective
          owners.

          Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
          mysql>


          if not, You must check:




          • network connection

          • my_slave user credentials, including allowed host, like my_slave%yyy.yyy.yyy.yyy where yyy.yyy.yyy.yyy - Your real ip address (in case of MAMP it could be ip of router). this is one of the frequent reasons for Error_code: 1130


          if all ok, You can make dump direct from slave:



          mysqldump --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password! --single-transaction --master-data=1 --all-databases > c:dumpsall_db.sql


          restore dump on slave:



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=root --password=slave_root_password < c:dumpsall_db.sql


          login to mysql console and start slave:



          mysql> start slave;


          generally - that all






          share|improve this answer
























          • So in your answer, you are making the entire collection of databases slave to those on another server, correct? I really only want to set it up for one database, is that possible? And how?

            – David Rhoderick
            Jun 2 '17 at 14:06











          • in this case --all-databases must be changed to --databases db_name , and in my.cnf (my.ini) defined - filter for single database , like -dev.mysql.com/doc/refman/5.6/en/…

            – a_vlad
            Jun 3 '17 at 4:00












          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f174792%2fslave-connection-1130%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          first of all You need to test connection from slave to master
          You can do this from command line (CMD windows)



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password!


          if it will be successful You will have normal mysql console



          Welcome to the MySQL monitor.  Commands end with ; or g.
          Your MySQL connection id is 29
          Server version: 5.7.15 MySQL Community Server (GPL)

          Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

          Oracle is a registered trademark of Oracle Corporation and/or its
          affiliates. Other names may be trademarks of their respective
          owners.

          Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
          mysql>


          if not, You must check:




          • network connection

          • my_slave user credentials, including allowed host, like my_slave%yyy.yyy.yyy.yyy where yyy.yyy.yyy.yyy - Your real ip address (in case of MAMP it could be ip of router). this is one of the frequent reasons for Error_code: 1130


          if all ok, You can make dump direct from slave:



          mysqldump --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password! --single-transaction --master-data=1 --all-databases > c:dumpsall_db.sql


          restore dump on slave:



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=root --password=slave_root_password < c:dumpsall_db.sql


          login to mysql console and start slave:



          mysql> start slave;


          generally - that all






          share|improve this answer
























          • So in your answer, you are making the entire collection of databases slave to those on another server, correct? I really only want to set it up for one database, is that possible? And how?

            – David Rhoderick
            Jun 2 '17 at 14:06











          • in this case --all-databases must be changed to --databases db_name , and in my.cnf (my.ini) defined - filter for single database , like -dev.mysql.com/doc/refman/5.6/en/…

            – a_vlad
            Jun 3 '17 at 4:00
















          0














          first of all You need to test connection from slave to master
          You can do this from command line (CMD windows)



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password!


          if it will be successful You will have normal mysql console



          Welcome to the MySQL monitor.  Commands end with ; or g.
          Your MySQL connection id is 29
          Server version: 5.7.15 MySQL Community Server (GPL)

          Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

          Oracle is a registered trademark of Oracle Corporation and/or its
          affiliates. Other names may be trademarks of their respective
          owners.

          Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
          mysql>


          if not, You must check:




          • network connection

          • my_slave user credentials, including allowed host, like my_slave%yyy.yyy.yyy.yyy where yyy.yyy.yyy.yyy - Your real ip address (in case of MAMP it could be ip of router). this is one of the frequent reasons for Error_code: 1130


          if all ok, You can make dump direct from slave:



          mysqldump --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password! --single-transaction --master-data=1 --all-databases > c:dumpsall_db.sql


          restore dump on slave:



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=root --password=slave_root_password < c:dumpsall_db.sql


          login to mysql console and start slave:



          mysql> start slave;


          generally - that all






          share|improve this answer
























          • So in your answer, you are making the entire collection of databases slave to those on another server, correct? I really only want to set it up for one database, is that possible? And how?

            – David Rhoderick
            Jun 2 '17 at 14:06











          • in this case --all-databases must be changed to --databases db_name , and in my.cnf (my.ini) defined - filter for single database , like -dev.mysql.com/doc/refman/5.6/en/…

            – a_vlad
            Jun 3 '17 at 4:00














          0












          0








          0







          first of all You need to test connection from slave to master
          You can do this from command line (CMD windows)



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password!


          if it will be successful You will have normal mysql console



          Welcome to the MySQL monitor.  Commands end with ; or g.
          Your MySQL connection id is 29
          Server version: 5.7.15 MySQL Community Server (GPL)

          Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

          Oracle is a registered trademark of Oracle Corporation and/or its
          affiliates. Other names may be trademarks of their respective
          owners.

          Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
          mysql>


          if not, You must check:




          • network connection

          • my_slave user credentials, including allowed host, like my_slave%yyy.yyy.yyy.yyy where yyy.yyy.yyy.yyy - Your real ip address (in case of MAMP it could be ip of router). this is one of the frequent reasons for Error_code: 1130


          if all ok, You can make dump direct from slave:



          mysqldump --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password! --single-transaction --master-data=1 --all-databases > c:dumpsall_db.sql


          restore dump on slave:



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=root --password=slave_root_password < c:dumpsall_db.sql


          login to mysql console and start slave:



          mysql> start slave;


          generally - that all






          share|improve this answer













          first of all You need to test connection from slave to master
          You can do this from command line (CMD windows)



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password!


          if it will be successful You will have normal mysql console



          Welcome to the MySQL monitor.  Commands end with ; or g.
          Your MySQL connection id is 29
          Server version: 5.7.15 MySQL Community Server (GPL)

          Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

          Oracle is a registered trademark of Oracle Corporation and/or its
          affiliates. Other names may be trademarks of their respective
          owners.

          Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
          mysql>


          if not, You must check:




          • network connection

          • my_slave user credentials, including allowed host, like my_slave%yyy.yyy.yyy.yyy where yyy.yyy.yyy.yyy - Your real ip address (in case of MAMP it could be ip of router). this is one of the frequent reasons for Error_code: 1130


          if all ok, You can make dump direct from slave:



          mysqldump --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password! --single-transaction --master-data=1 --all-databases > c:dumpsall_db.sql


          restore dump on slave:



          mysql --host=xxx.xxx.xxx.xx --port=3306 --user=root --password=slave_root_password < c:dumpsall_db.sql


          login to mysql console and start slave:



          mysql> start slave;


          generally - that all







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered May 29 '17 at 3:36









          a_vlada_vlad

          3,0421716




          3,0421716













          • So in your answer, you are making the entire collection of databases slave to those on another server, correct? I really only want to set it up for one database, is that possible? And how?

            – David Rhoderick
            Jun 2 '17 at 14:06











          • in this case --all-databases must be changed to --databases db_name , and in my.cnf (my.ini) defined - filter for single database , like -dev.mysql.com/doc/refman/5.6/en/…

            – a_vlad
            Jun 3 '17 at 4:00



















          • So in your answer, you are making the entire collection of databases slave to those on another server, correct? I really only want to set it up for one database, is that possible? And how?

            – David Rhoderick
            Jun 2 '17 at 14:06











          • in this case --all-databases must be changed to --databases db_name , and in my.cnf (my.ini) defined - filter for single database , like -dev.mysql.com/doc/refman/5.6/en/…

            – a_vlad
            Jun 3 '17 at 4:00

















          So in your answer, you are making the entire collection of databases slave to those on another server, correct? I really only want to set it up for one database, is that possible? And how?

          – David Rhoderick
          Jun 2 '17 at 14:06





          So in your answer, you are making the entire collection of databases slave to those on another server, correct? I really only want to set it up for one database, is that possible? And how?

          – David Rhoderick
          Jun 2 '17 at 14:06













          in this case --all-databases must be changed to --databases db_name , and in my.cnf (my.ini) defined - filter for single database , like -dev.mysql.com/doc/refman/5.6/en/…

          – a_vlad
          Jun 3 '17 at 4:00





          in this case --all-databases must be changed to --databases db_name , and in my.cnf (my.ini) defined - filter for single database , like -dev.mysql.com/doc/refman/5.6/en/…

          – a_vlad
          Jun 3 '17 at 4:00


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f174792%2fslave-connection-1130%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Liste der Baudenkmale in Friedland (Mecklenburg)

          Single-Malt-Whisky

          Czorneboh