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!
Did you ever get to the bottom of this? I’m experiencing something similar.
Edit: I hadn’t correctly set up Metricbeat. Solved.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.