Unknown process logging error : Access denied for user 'root'@'localhost' (using password: YES) on MySQL Slave Server.

September 29, 2017 1.9k views
MySQL Ubuntu 16.04

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.

1 Answer

Did you ever get to the bottom of this? I'm experiencing something similar.

Edit: I hadn't correctly set up Metricbeat. Solved.

Have another answer? Share your knowledge.