Stuck with MySQL permission

[truongdqse03303]

Hi experts
I'm trying to config my metricbeat to track MySQL server.
Here is my config mysql

The result kibana collected is
I already use the query
GRANT ALL ON . to root@'%' IDENTIFIED BY 'pass';
in sql still error
How can i pass the error 1130.
Thanks

[exekias (Carlos Pérez Aradros)]

I would recommend to ensure your credentials are working with mysql client as it will make tests easier. Your command looks ok to me, did you flush privileges? It should be something like this:

GRANT ALL PRIVILEGES ON *.* TO root@’%’ IDENTIFIED BY ‘pass’;
FLUSH PRIVILEGES;

[truongdqse03303]

Hi @exekias tks for fast reply
Yes i did.
I follow https://stackoverflow.com/questions/2857446/error-1130-in-mysql but not working for me for some reason
Is it not allow root user or other reason?
If not have the solution can you show me if you have to analyze mysql with metricbeat, what do you do each strep?
Thank you for all

[Dami (Damian)]

Isn't too many privileges for a monitoring user account? Using root for monitoring wont be following best practices.
Do you know what are the minimum privileges requirements ?