An Annoying MySQL Replication Error Code: 1045

I was fixing MySQL replication on a slave this past week. Everything seemed to be ready to go after bringing data over from the master manually. I went to connect the slave to the master and nothing happened. Whaaaaaa? Last_IO_Errno: 1045 Last_IO_Error: error connecting to master 'repl@blah.local:3306' - retry-time: 60 retries: 86400 Let me look up MySQL error code 1045: Error: 1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR) Message: Access denied for user '%s'@'%s' (using password: %s) That’s not helpful....

October 5, 2015 · 1 min · Chris Short