Resolved error open phpmyadmin

[fferraro87]

Hi,
i've plesk obsidian 18.0.19 installed on a centos 7 vps, today i've tried to browse a db with phpmyadmin but when i click on phpmyadmin i've that error :

 Messaggio di MySQL: Documentazione
#1142 - SELECT command denied to user 'pma_9CCa0CBxiZwX'@'localhost' for table 'pma_column_info

How can i fix it?

 

[IgorG]

The issue is caused by a mismatch between user login credentials stored in the phpMyAdmin configuration and the database.
The fastest way to fix the issue is to reinstall PhpMyAdmin:

Remove PhpMyAdmin

# rpm -e --nodeps psa-phpmyadmin

Install it correctly with

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
# plesk repair installation

 

[fferraro87]

Hi

The issue is caused by a mismatch between user login credentials stored in the phpMyAdmin configuration and the database.
The fastest way to fix the issue is to reinstall PhpMyAdmin:

Remove PhpMyAdmin

# rpm -e --nodeps psa-phpmyadmin

Install it correctly with

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
# plesk repair installation

Thanks, i've done, but i've still same problem.

it's only change pma user :

#1142 - SELECT command denied to user 'pma_wggggXXa0fjQ'@'localhost' for table 'pma_column_info'

 

[Jean.TopOnWeb]

Hi, had the same issue today but all it took was clearing the cookies from the browser and it was fixed.
So maybe try that or using a different browser (if you haven't already).

 

[fferraro87]

Hi, had the same issue today but all it took was clearing the cookies from the browser and it was fixed.
So maybe try that or using a different browser (if you haven't already).

Thanks a lot, you're right!

 

[JorgB]

Hi, had the same issue today but all it took was clearing the cookies from the browser and it was fixed.
So maybe try that or using a different browser (if you haven't already).

Thanks! Almost did a complete reinstall of PMA

 

[Kuhlma]

Thanks a lot, you're right!

I also had the same problem. The deletion of the browser cache was my solution, too!

 

[garcue]

Hi, had the same issue today but all it took was clearing the cookies from the browser and it was fixed.
So maybe try that or using a different browser (if you haven't already).

Thanks, I had the same problem and I just fixed it