Bug #21176 "reset slave" sets master_user to 'test'
Submitted: 20 Jul 2006 11:21 Modified: 20 Jul 2006 16:40
Reporter: Bernd Ocklin Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1.12 (current snapshot) OS:Linux (Linux 2.6.11)
Assigned to: CPU Architecture:Any

[20 Jul 2006 11:21] Bernd Ocklin
Description:
mysql> reset master;

command will set the master-user to 'test'. All other master_host, master_password remain. Functionality "all binary logs listed in the index file, resets the binary log index file to beempty, and creates a new binary log file." works as designed.

How to repeat:
mysql> change master to master_host='foo', master_user='repl', master_password='repl', master_log_file='foo-bin.000001', master_log_pos=102;
mysql> start slave;
mysql> stop slave;
mysql> reset slave;
mysql> start slave;

mysql> show slave status\G

*************************** 1. row ***************************
             Slave_IO_State: Connecting to master
                Master_Host: foo
                Master_User: test
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: 
        Read_Master_Log_Pos: 4
             Relay_Log_File: foo-relay-bin.000002
              Relay_Log_Pos: 102
      Relay_Master_Log_File: 
           Slave_IO_Running: No
          Slave_SQL_Running: Yes
            Replicate_Do_DB: 
        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: 0
            Relay_Log_Space: 102
            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
1 row in set (0.00 sec)

Suggested fix:
Do not replace master_user by test.
[20 Jul 2006 15:52] Valeriy Kravchuk
Thank you for a problem report. Yes, it works as you described, but it is not a bug. Please, read the manual (http://dev.mysql.com/doc/refman/5.1/en/reset-slave.html):

"Connection information stored in the master.info file is immediately reset using any values specified in the corresponding startup options. This information includes values such as master host, master port, master user, and master password."