PHPMyAdmin 'database_name.pma_tracking' doesn't exist

[HowardE]

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



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.

 

[cPRex]

Hey there! I'd start with the following before trying any deeper changes:

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]

Hi, thanks for the answer. Unfortunately, that didn't change anything.

 /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

 

[cPRex]

I was hoping that would do it! I don't have a guide handy for rebuilding the internal PHPMyAdmin tables, so it might be best to submit a ticket to our team to do some additional research on that behavior.