Report this

What is the reason for this report?

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

Posted on September 29, 2017

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.



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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

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

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.