CODEWITHSUNDEEP
phpphpmyadminxampp
Mayuresh Kulkarni
Mayuresh Kulkarni

Reputation: 51

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

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.

Upvotes: 5

Views: 10466

Answers (3)

Rana Nadeem
Rana Nadeem

Reputation: 1225

enter image description here

Click on this. That will fix the issue.

Upvotes: 29

Mohammad Ali Abdullah
Mohammad Ali Abdullah

Reputation: 331

  1. 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'] = '';

  2. 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

  3. I run this sql statement:

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

Upvotes: 1

kanguurek
kanguurek

Reputation: 87

try to change address from localhost to 127.0.0.1

Upvotes: 8

Related Questions