| 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: | |
| 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 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."
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.