PHPMyAdmin 'database_name.pma_tracking' doesn't exist

HowardE

Member
Aug 8, 2015
20
2
53
Florida
cPanel Access Level
Root Administrator
I recently imported an sql file to a client database using the command line. This database apparently had some tables .pma_ etc... I removed this database, and now phpMyAdmin as Root doesn't work right. Every click gets me errors showing

1616010871160.png

I can use PHPMyAdmin as a user under their cpanel, but when I use the WHM Root phpmyadmin, i get only this error. I didn't want to re-install this other database as a solution.

Everything I've found online suggests re-installing the \phpMyAdmin\sql but I didn't find anything specific to WHM/cPanel.

Any help would be appreciated.

Thanks.
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
4,871
601
273
cPanel Access Level
Root Administrator
Hey there! I'd start with the following before trying any deeper changes:

Code:
rpm -e --nodeps cpanel-phpmyadmin
/scripts/check_cpanel_rpms
You will need to push "y" to confirm the RPM reinstall while the second command runs.

Can you try that and see if that gets things working?
 

HowardE

Member
Aug 8, 2015
20
2
53
Florida
cPanel Access Level
Root Administrator
Hi, thanks for the answer. Unfortunately, that didn't change anything.

Code:
 /scripts/check_cpanel_rpms
[2021-03-17 17:50:35 -0400]
[2021-03-17 17:50:35 -0400]   Problems were detected with cPanel-provided files which are RPM controlled.
[2021-03-17 17:50:35 -0400]   If you did not make these changes intentionally, you can correct them by running:
[2021-03-17 17:50:35 -0400]
[2021-03-17 17:50:35 -0400]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
[2021-03-17 17:50:35 -0400]   The following RPMs are missing from your system:
[2021-03-17 17:50:35 -0400]   cpanel-phpmyadmin-4.9.5-1.cp1186
Do you want to repair these RPMs?(y/n):
y
[2021-03-17 17:51:20 -0400]   Removing 0 broken rpms:
[2021-03-17 17:51:20 -0400]   rpm: no packages given for erase
[2021-03-17 17:51:20 -0400]   Maximum sync children set to 16 based on 21545M available memory.
[2021-03-17 17:51:20 -0400]   Downloading http://httpupdate.cpanel.net/RPM/11.86/centos/7/x86_64/rpm.sha512
[2021-03-17 17:51:27 -0400]   Successfully verified signature for cpanel (key types: release).
[2021-03-17 17:51:27 -0400]   Maximum sync children set to 16 based on 21403M available memory.
[2021-03-17 17:51:27 -0400]   Downloading http://httpupdate.cpanel.net/RPM/11.86/centos/7/x86_64/cpanel-phpmyadmin-4.9.5-1.cp1186.noarch.rpm
[2021-03-17 17:51:28 -0400]   Disabling service monitoring.
[2021-03-17 17:51:28 -0400]   Hooks system enabled.
[2021-03-17 17:51:28 -0400]   Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed
[2021-03-17 17:51:28 -0400]   All required 'pre' hooks have been run
[2021-03-17 17:51:29 -0400]   No RPMS need to be uninstalled
[2021-03-17 17:51:29 -0400]   Installing new rpms: cpanel-phpmyadmin-4.9.5-1.cp1186.noarch.rpm
[2021-03-17 17:51:29 -0400]   Preparing packages...
[2021-03-17 17:51:29 -0400]   cleaning up old phpmyadmin before installing new one.
[2021-03-17 17:51:29 -0400]   We only do this the first time we install the cpanel-phpmyadmin RPM
[2021-03-17 17:51:29 -0400]   cpanel-phpmyadmin-4.9.5-1.cp1186.noarch
[2021-03-17 17:51:35 -0400]   Releasing lock for Cpanel::RPM::Versions::File
[2021-03-17 17:51:35 -0400]   Hooks system enabled.
[2021-03-17 17:51:35 -0400]   Checking for and running RPM::Versions 'post' hooks for any RPMs about to be installed
[2021-03-17 17:51:35 -0400]   All required 'post' hooks have been run
[2021-03-17 17:51:35 -0400]   Restoring service monitoring.
The Error is still the same though