• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

Resolved error open phpmyadmin

fferraro87

Basic Pleskian
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 :

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

How can i fix it?
 
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
 
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 :

Code:
#1142 - SELECT command denied to user 'pma_wggggXXa0fjQ'@'localhost' for table 'pma_column_info'
 
Back
Top