Database user lacks privileges
New announcements from Dash: Incident Management, Continuous Profiler, and more! New announcements from Dash!

Database user lacks privileges

    mysql
    -----
      - instance #0 [WARNING]
          Warning: Privilege error or engine unavailable accessing the INNODB status                          tables (must grant PROCESS): (1227, u'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation')
      - Collected 21 metrics, 0 events & 1 service check

The Agent can authenticate, but it lacks privileges for one or more metrics it wants to collect. In this case, it lacks the PROCESS privilege:

mysql> select user,host,process_priv from mysql.user where user='datadog';
+---------+-----------+--------------+
| user    | host      | process_priv |
+---------+-----------+--------------+
| Datadog | localhost | N            |
+---------+-----------+--------------+
1 row in set (0.00 sec)

Review the Configuration section and grant the Datadog user all necessary privileges. Do NOT grant all privileges on all databases to this user.

On this Page