MySQL Forums
Forum List  »  Replication

Troubleshoot "permission denied" from START SLAVE
Posted by: Markham Anderson
Date: March 24, 2021 08:14PM

When setting up a replication server, I can successfully connect to my main server using the `mysql` command-line tool:

mysql -u REMOTE_USER -P REMOTE_PORT -h REMOTE_HOST -p REMOTE_DATABASE

However, when I try to `START SLAVE`, the connection fails with the message `Can't connect to MySQL server on 'REMOTE_HOST' (13 "Permission denied")`.

Stranger still, the general log on the main server shows the cli `mysql`'s successful connection but doesn't show any attempts from the `START SLAVE` command. (If I intentionally use the wrong password with the cli `mysql`, though, the general log does show that failed attempt.) **How can I troubleshoot this?**

`SHOW SLAVE STATUS` outputs the following:

                Slave_IO_State: Connecting to master
                   Master_Host: REMOTE_HOST
                   Master_User: REMOTE_USER
                   Master_Port: REMOTE_PORT
                 Connect_Retry: 60
               Master_Log_File: mysql-bin.041115
           Read_Master_Log_Pos: 569520669
                Relay_Log_File: mysql-relay-bin.000001
                 Relay_Log_Pos: 4
         Relay_Master_Log_File: mysql-bin.041115
              Slave_IO_Running: Connecting
             Slave_SQL_Running: Yes
               Replicate_Do_DB: REMOTE_DATABASE
           Replicate_Ignore_DB: 
            Replicate_Do_Table: 
        Replicate_Ignore_Table: 
       Replicate_Wild_Do_Table: 
   Replicate_Wild_Ignore_Table: 
                    Last_Errno: 0
                    Last_Error: 
                  Skip_Counter: 0
           Exec_Master_Log_Pos: 569520669
               Relay_Log_Space: 256
               Until_Condition: None
                Until_Log_File: 
                 Until_Log_Pos: 0
            Master_SSL_Allowed: No
            Master_SSL_CA_File: 
            Master_SSL_CA_Path: 
               Master_SSL_Cert: 
             Master_SSL_Cipher: 
                Master_SSL_Key: 
         Seconds_Behind_Master: NULL
 Master_SSL_Verify_Server_Cert: No
                 Last_IO_Errno: 2003
                 Last_IO_Error: error connecting to master 'REMOTE_USER@REMOTE_HOST:REMOTE_PORT' - retry-time: 60  maximum-retries: 86400  message: Can't connect to MySQL server on 'REMOTE_HOST' (13 "Permission denied")
                Last_SQL_Errno: 0
                Last_SQL_Error: 
   Replicate_Ignore_Server_Ids: 
              Master_Server_Id: 0
                Master_SSL_Crl: 
            Master_SSL_Crlpath: 
                    Using_Gtid: No
                   Gtid_IO_Pos: 
       Replicate_Do_Domain_Ids: 
   Replicate_Ignore_Domain_Ids: 
                 Parallel_Mode: conservative
                     SQL_Delay: 259200
           SQL_Remaining_Delay: NULL
       Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
              Slave_DDL_Groups: 0
Slave_Non_Transactional_Groups: 0
    Slave_Transactional_Groups: 0

Options: ReplyQuote


Subject
Views
Written By
Posted
Troubleshoot "permission denied" from START SLAVE
783
March 24, 2021 08:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.