In phpMyAdmin in my server, When trying to view the table USER_STATISTICS in information_schema Database, This error comes in. Is it normal or need something to be done ?
Asked
Active
Viewed 853 times
0
Dharman
- 30,962
- 25
- 85
- 135
Tharindu Thisarasinghe
- 3,846
- 8
- 39
- 70
-
go to privilege tab on top links and edit the privileges. – Fakhruddin Ujjainwala Feb 24 '16 at 12:11
-
@FakhruddinUjjainwala I can't see such a tab :( – Tharindu Thisarasinghe Feb 24 '16 at 12:14
-
Have you login with your `root` user `privileges`? – Jayesh Patel Feb 24 '16 at 12:19
-
@TharinduLucky check out my answer below. – Fakhruddin Ujjainwala Feb 24 '16 at 12:20
-
This is how the USER_PREVILEGES table look like https://www.dropbox.com/s/k4m50qjw51qvzaf/Untitled.png?dl=0 – Tharindu Thisarasinghe Feb 24 '16 at 12:20
-
@TharinduLucky just substitute the user name and password in the answer below and run the query in `phpmyadmin` it will solve your issue. – Fakhruddin Ujjainwala Feb 24 '16 at 12:22
1 Answers
0
Try this out, just execute this query as root user:
GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';
Fakhruddin Ujjainwala
- 2,493
- 17
- 26
-
Thanks but, I want to know why this is happening. This is my login user and I don't have full access... Why ? – Tharindu Thisarasinghe Feb 24 '16 at 12:24
-
-
This is the error I get after the execution of ur code https://www.dropbox.com/s/k4m50qjw51qvzaf/Untitled.png?dl=0 – Tharindu Thisarasinghe Feb 24 '16 at 12:33
-
@TharinduLucky you are not logged in using root privileges. Please get the root id and pwd from database administrator. – Fakhruddin Ujjainwala Feb 24 '16 at 12:36
-
I'm the owner of this hosting account and where to get or find that credentials ? – Tharindu Thisarasinghe Feb 24 '16 at 12:38