# problem when grant permissions

**URL:** <https://forum.virtualmin.com/t/problem-when-grant-permissions/30527>\
**Category:** Help! (Home for newbies)\
**Created:** [September 5, 2008, 12:50pm UTC](https://forum.virtualmin.com/t/problem-when-grant-permissions/30527 "2008-09-05T12:50:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![allie](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@allie](https://forum.virtualmin.com/u/allie)\
**Post date:** [September 5, 2008, 12:50pm UTC](https://forum.virtualmin.com/t/problem-when-grant-permissions/30527/1 "2008-09-05T12:50:35Z")

</div>

Hi My site went down. [flics.lfhub.com](http://flics.lfhub.com)  
I couldn’t figure out why and was tinkering with the settings.  
I tried to grant permissions in mysql and now I have the following message on all the permission pages and I can’t figure out how to fix it:

SQL select \* from user order by user failed : SELECT command denied to user 'root'@'localhost' for table 'user'

Please help!

I just realized that I had changed my password prior to changing the permissions can this be the problem?\<br\>\<br\>Post edited by: allie, at: 2008/09/05 10:29

---

<div class="post-metadata">

**Author:** ![system](https://cdn.forum.virtualmin.com/uploads/default/original/2X/c/cd96d761e326db4b2bef94886a639109bd7a8e76.svg) [@system](https://forum.virtualmin.com/u/system)\
**Post date:** [April 30, 2020, 5:30am UTC](https://forum.virtualmin.com/t/problem-when-grant-permissions/30527/2 "2020-04-30T05:30:43Z")

</div>

Closed on April 30, 2020, 5:30am UTC