"#1142 SELECT command denied to user ' '@'localhost' for table pma_tracking"?

Question

In Xampp phpMyAdmin, when I click on database name I'm getting an error

"#1142 SELECT command denied to user ' '@'localhost' for table pma_tracking".

What should I do in-order to rectify this error? I am using Windows 10.

https://stackoverflow.com/questions/18424797/1142-select-command-denied-to-user-localhost-for-table-pma-table-uipref/18428475 — Muhammad Usman, Jul 19 '17 at 17:43
Possible duplicate of [#1142 - SELECT command denied to user ''@'localhost' for table 'pma\_table\_uiprefs'](https://stackoverflow.com/questions/18424797/1142-select-command-denied-to-user-localhost-for-table-pma-table-uipref) — Osama AbuSitta, Jul 19 '17 at 18:00

score 29 · Answer 1 · answered Jun 21 '20 at 07:41

29

Click on this. That will fix the issue.

answered Jun 21 '20 at 07:41

Rana Nadeem

score 8 · Answer 2 · answered Oct 23 '19 at 17:12

8

try to change address from localhost to 127.0.0.1

answered Oct 23 '19 at 17:12

kanguurek

The original poster was able to solve the problem quite a while ago. How does this change that answer? – stdunbar Oct 23 '19 at 17:34
This helped me. Thanks! – Dumitru Nov 07 '19 at 22:00
I tried this and the problem is fixed, can you tell me where the problem is? why when using 'localhost' the problem persists? – MR. A Jun 27 '20 at 13:17

score 1 · Answer 3 · edited Mar 18 '20 at 09:59

I opened xampp\phpMyAdmin\config.inc.php file and found the following lines:

/* User for advanced features */\\

$cfg['Servers'][$i]['controluser'] = 'pma';

$cfg['Servers'][$i]['controlpass'] = '';
Then I observed in phpmyadmin the following tables:

DATABASE: phpmyadmin

TABLES: pma_bookmark pma_column_info pma_designer_coords pma_history pma_pdf_pages pma_recent pma_relation pma_table_coords pma_table_info pma_table_uiprefs pma_tracking pma_userconfig
I run this sql statement:

GRANT SELECT , INSERT , UPDATE , DELETE ON phpmyadmin.* TOpma@localhostIDENTIFIED BY ''

3 Answers3