Mysql Replication Error 1045
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss error connecting to master mysql replication the workings and policies of this site About Us Learn more error connecting to master - retry-time 60 retries 86400 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow error connecting to master ' 3306' - retry-time 60 retries 86400 Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping mysql replication error connecting to master 2003 each other. Join them; it only takes a minute: Sign up 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:
Last_io_error Error Connecting To Master
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 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,89573872 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
again in a few minutes. CloudFlare Ray ID: 2f50a2dedf9d0f8d • Your IP: 93.127.148.66 • Performance & security by CloudFlare
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://dba.stackexchange.com/questions/86194/mysql-slave-replication-permission-error more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question http://serverfault.com/questions/282602/failed-to-connect-from-slave-to-master-with-error-error-connecting-to-master-1 and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody error connecting can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL slave replication permission error up vote 1 down vote favorite I am having a rather frustrating issue. I have granted replication client to a user on the slave instance of MySQL. I can login using the username and password. I can exectute "SHOW SLAVE STATUS;" but I cannot start or error connecting to stop the slave thread. I get the error below when i issue "STOP SLAVE" or "START SLAVE". ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) Any ideas on how to resolve this? Thanks. mysql replication share|improve this question edited Dec 15 '14 at 10:19 asked Dec 15 '14 at 10:10 ace 285 the error meaning when trying to connect to MySQL you entered the wrong password or no password at all –Ahmad Abuhasna Dec 15 '14 at 10:14 @ahmad, I am already connected and in the MySQL commandline. –ace Dec 15 '14 at 10:17 when the slave SID to to replicate Master SID it required user name and password MASTER_USER and MASTER_PASSWORD to log in and replicate, if the master password is blank or wrong you will get the same error message –Ahmad Abuhasna Dec 15 '14 at 10:24 @ahmad, replication on the server is working fine. I just need the user to be able to start and stop the slave thread. –ace Dec 15 '14 at 10:30 you may need to grant super privileges to the user. Replication client is responsible only to replicate binary logs to slave. –Nawaz
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta 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: 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 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 Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 0 1 row in set (0.00 sec) Is this caused by different version of MySQL server? The version of master is 5.0.77, and the slave is 5.5.13. But all articles I could find tell me that it's okay to replicate from a newer slave to old master. How to solve this problem? -- Update -- I even try to upgrade the old MySQL, b