Unknown process logging error : Access denied for user 'root'@'localhost' (using password: YES) on MySQL Slave Server.
I’ve setup a master/slave replication on two independent servers using the one-click app (MySQL on 16.04 Ubuntu).
Everything is working properly and I’m not seeing any issues, but my error log on the slave database is getting this error every minute or so.
2017-09-29T16:08:11.750257Z 452 [Note] Access denied for user ‘root’@'localhost’ (using password: YES)
I’m guess there’s a process pinging the database. Maybe a health-check or something. Obviously this isn’t going to work as I’ve bound the IP address to the private IP rather than localhost. I’d like to track down exactly where this is coming from and either fix it to use the proper private IP address or turn it off.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.