# Stuck with MySQL permission

**URL:** <https://discuss.elastic.co/t/stuck-with-mysql-permission/97594>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [August 18, 2017, 1:45pm UTC](https://discuss.elastic.co/t/stuck-with-mysql-permission/97594 "2017-08-18T13:45:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![truongdqse03303](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/truongdqse03303/32/22605_2.png) [@truongdqse03303](https://discuss.elastic.co/u/truongdqse03303)\
**Post date:** [August 18, 2017, 1:45pm UTC](https://discuss.elastic.co/t/stuck-with-mysql-permission/97594/1 "2017-08-18T13:45:30Z")

</div>

Hi experts  
I'm trying to config my metricbeat to track MySQL server.  
Here is my config mysql  
 ![1](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a29c09839d9a169b8f7fe4c8416ed88499b6113.PNG)  
The result kibana collected is ![2](https://us1.discourse-cdn.com/elastic/original/3X/d/5/d5691ea2721f1d4025c381da73258f1bf2274c14.PNG)  
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

---

<div class="post-metadata">

**Author:** ![exekias](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/exekias/32/28718_2.png) [@exekias](https://discuss.elastic.co/u/exekias)\
**Post date:** [August 18, 2017, 2:35pm UTC](https://discuss.elastic.co/t/stuck-with-mysql-permission/97594/2 "2017-08-18T14:35:45Z")

</div>

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:

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

```

---

<div class="post-metadata">

**Author:** ![truongdqse03303](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/truongdqse03303/32/22605_2.png) [@truongdqse03303](https://discuss.elastic.co/u/truongdqse03303)\
**Post date:** [August 18, 2017, 3:04pm UTC](https://discuss.elastic.co/t/stuck-with-mysql-permission/97594/3 "2017-08-18T15:04:27Z")

</div>

Hi @exekias tks for fast reply  
Yes i did.  
I follow [https://stackoverflow.com/questions/2857446/error-1130-in-mysql](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

---

<div class="post-metadata">

**Author:** ![Dami](https://avatars.discourse-cdn.com/v4/letter/d/d2c977/32.png) [@Dami](https://discuss.elastic.co/u/Dami)\
**Post date:** [September 14, 2017, 4:59pm UTC](https://discuss.elastic.co/t/stuck-with-mysql-permission/97594/4 "2017-09-14T16:59:50Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 12, 2017, 5:00pm UTC](https://discuss.elastic.co/t/stuck-with-mysql-permission/97594/5 "2017-10-12T17:00:02Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.