You might noticed MySQL statistics aren’t being show in Netdata. Here’s what I ran into.
Error: “MySQLdb or PyMySQL module is needed to use mysql.chart.py plugin”
The required python libraries for MySQL are missing, so you simply need to install them. For Ubuntu/Debian the following command should correct it.
Setting up Netdata MySQL User
You might also see these errors in your log.
The fix is simple, add a user called Netdata with a password. Note, you can setup the Netdata user without a password, but this may expose information to the system that you might not want. Full information is located on Netdata’s website.
So let’s get Netdata pulling MySQL data.
Fast, open and potentially insecure no password optiom
This will just work, but leave a user on your MySQL instance without a password.
Password based polling
Let’s run the same command as above but give the user a password.
Now we need to tell Netdata the password.
Instead of editing the defaults, go to the bottom of the config and just create a new section with the following
Now you should see MySQL metrics in Netdata