Score:1

MariaDB / MySql Warning after Netdata installation. "Access denied for user 'netdata'@'localhost' (using password: NO)" How to fix?

mx flag

I have configured Netdata on an Ubuntu 20.04 Server LEMP server, according to this Linuxbabe.com tutorial.

After installation, I run the following command

sudo systemctl status mariadb.service

which returns the following warning:

[Warning] Access denied for user 'netdata'@'localhost' (using password: NO)
  1. What does this mean in regards to Netdata functionality?
  2. Does this mean Netdata is misconfigured?
  3. What can I do to fix it?
Score:0
eg flag

Have you created a netdata user in the db as per here?

Netdata needs its own db user with specific privileges.

https://learn.netdata.cloud/docs/data-collection/database-servers/mysql-and-mariadb#create-netdata-user

DanRan avatar
mx flag
Thanks @andrewm4894. I installed netdata with the netdata setup script using the command `bash <(curl -Ss https://my-netdata.io/kickstart.sh) --disable-telemetry`. Netdata is working. But when I run `SELECT user FROM mysql.user;` in mariadb, no "netdata" user appears. How is netdata working without a database user? What did the setup script do to make things work without using a netdata db user?
DanRan avatar
mx flag
Also when I run `SHOW DATABASES;' in mysql, I see no database for netdata. So apparently netdata is running without a database and database user. How is this possible?
andrewm4894 avatar
eg flag
@DanRan you need to create a netdata user as per docs link i shared.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.