Error Connecting To Master 1045
Contents |
followed by SHOW SLAVE STATUS\G, and see this error? Last_IO_Errno: 1045 Last_IO_Error: error connecting to master 'slave_user@master.domain.int:3306' - retry-time: 60 retries: 86400 and error_code 1045 mysql your log file shows: 110201 22:53:26 [Note] 'CHANGE MASTER TO executed'. Previous state
Error Connecting To Master - Retry-time 60 Retries 86400
master_host='master.domain.int', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='10.0.0.10', master_port='3306', master_log_file='mysql-bin.000001', master_log_pos='106'. 110201 22:53:26 [Note] Slave SQL thread initialized, starting replication in error connecting to master error_code 2003 log 'mysql-bin.000001' at position 106, relay log '/mnt/mysql/logs/relay-bin.000001' position: 4 110201 22:53:26 [ERROR] Slave I/O: error connecting to master 'slave-user@10.0.0.10:3306' - retry-time: 60 retries: 86400, Error_code: 1045 The master isn't rejecting your password, last_io_error error connecting to master and there isn't useful feedback indicating why the slave cannot connect. Note the error code 1045, which indicates a credentials problem. Double-check the length of your password; MySQL has a MASTER_PASSWORD maximum length limit of 32 characters. Shorten that puppy up and have another try. From the command line, you can issue a command such as mysql --user=slave-user --host=master -p to verify that your credentials are
Last_io_error Error Connecting To Master ' Replication
valid. However, be aware that you can connect this way with a password that is too long and that will not work for replication. And as John_A points out in the comments: "turns out you cannot use a pound sign ‘#' when your password is in my.cnf either. A work around is to copy the password into your master.info file." Also, double-check that neither firewalls nor SELinux are blocking the connection; you can telnet master 3306 to verify that MySQL is listening and accepting connections on that port. More MySQL variable restrictions at: MySQL :: MySQL 5.1 Reference Manual :: 12.5.2.1 CHANGE MASTER TO Syntax. Be Sociable, Share! Tweet MySQL , replication
How-To 8 Comments February 1st, 2011 Share Comments Yulianto SidabutarOctober 22nd, 2011 Good Adviced. Thx! ScottApril 11th, 2012 You Sir, just fixed my problem after a good 2 hours troubleshooting. Thank fuck you were born! arunMay 17th, 2012 thanks for the help …. I appreciate it keep writing 🙂 Clayton A. AlvesAugust 24th, 2013 Thank u man. RuudApril 19th, 2014 Thanks for the tip regarding the 32-char master password. Mine was 50, which didn't worked 🙁 Daniel K.May 27th, 2014 Thhere for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of mysql error 1045 28000 this site About Us Learn more about Stack Overflow the company Business Learn error connecting to master mysql replication more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Slave_io_running: Connecting
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up http://nerdherd.com/archives/524 mysql master slave replcation Error 1045 up vote 3 down vote favorite *********************** 1. row ************************ Slave_IO_State: Connecting to master Master_Host: x.x.x.x. Master_User: slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 2190425 Relay_Log_File: mysql-relay-bin.000002 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql-bin.000001 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: 2190425 Relay_Log_Space: 106 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No http://stackoverflow.com/questions/20971596/mysql-master-slave-replcation-error-1045 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: 1045 Last_IO_Error: error connecting to master 'slave@x.x.x.x:3306' - retry-time: 60 retries: 86400 Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.00 sec) ERROR: No query specified mysql share|improve this question edited Jan 7 '14 at 12:28 Bhushan 3,88273872 asked Jan 7 '14 at 12:25 user3089570 1613 Please describe the slave's login. Did you grant its user the replication privilege on the master? dev.mysql.com/doc/refman/5.0/en/replication-howto-repuser.html –Michael Berkowski Jan 7 '14 at 12:30 yes i did .. actually i m able to login with this slave user thru Putty on Slave server... –user3089570 Jan 8 '14 at 5:14 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Hunted high and low with an identical problem, turns out you cannot use a pound sign ‘#’ when your password is in my.cnf either. A work around is to copy the password into your master.info file. share|improve this answer answered Oct 6 '14 at 19:14 John_A 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://serverfault.com/questions/282602/failed-to-connect-from-slave-to-master-with-error-error-connecting-to-master-1 Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: error connecting Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Failed to connect from slave to master with error “error connecting to master (1045)” up vote 4 down vote favorite 1 I try to setup replication from slave to the master. CHANGE MASTER TO error connecting to MASTER_HOST = 'master', MASTER_PORT = 3306, MASTER_USER = 'repl', MASTER_PASSWORD = 'xxx'; And I did grant privileges to the user on master. I can connect with mysql command from slave machine to the master mysql -h master -u repl -p mysql> show grants; GRANT RELOAD, SUPER, REPLICATION SLAVE, CREATE USER ON *.* TO 'repl'@'xxx' IDENTIFIED BY PASSWORD 'xxx' mysql> select 1; +---+ | 1 | +---+ | 1 | +---+ 1 row in set (0.04 sec) As you can see, privileges are correct, connection works fine, but however, the connection for replication to master always failed. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: master Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: slave-replay-bin.000002 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: Connecting 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: 107 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: 1045 Last_IO_Error: error connecting to master 'repl@master:3306' - retry-time: 60 retries: 86400 La