PHPmyAdmin Errors

PHP
1

All,

Never had any issues with PHPmyAdmin before, but recently installed PHPmyAdmin on a new server and getting all these errors:

Login Page:

Connection for controluser as defined in your configuration failed.

General Settings Page:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
Connection for controluser as defined in your configuration failed.
The mcrypt extension is missing. Please check your PHP configuration.

Server: localhost » Database Page:

Connection for controluser as defined in your configuration failed.
Connection for controluser as defined in your configuration failed.

Server: localhost » Database: SQL TAB:

Connection for controluser as defined in your configuration failed.
Connection for controluser as defined in your configuration failed.
Connection for controluser as defined in your configuration failed.

Server: localhost » Database: IMPORT TAB:

Could not save recent table

#1146 - Table 'phpmyadmin.pma_recent' doesn't exist
Connection for controluser as defined in your configuration failed.
Connection for controluser as defined in your configuration failed.

Browse or Query Attempt:

Error

SQL query: DocumentationEdit Edit

SELECT `prefs`
FROM `phpmyadmin`.`pma_table_uiprefs`
WHERE `username` = 'root'
AND `db_name` = 'dhcare'
AND `table_name` = 'dh_prod'

MySQL said: Documentation
#1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist

I have always added the following lines to the config.inc.php file:

// User defined settings follow:
$cfg['ExecTimeLimit'] = 0;
$cfg['LoginCookieValidity'] = 60*60*24*3;
$cfg['MaxRows'] = 200;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['Servers'] [$i] ['LoginCookieValidity'] = "60 * 60 * 24 * 3";
$cfg['ThemeDefault'] = 'original';

but none of these are pertainent to the errors occuring.

It appears that the phpmyadmin.sql file used to init this install, was/is incomplete. I have an old backup version, so planning to load that and see what changes.

If I still have errors, I’ll followup here. Not sure about that “control user” thing, so will still need to figure that one out.

Cheers!

TBNK

2

All,

I was right! Imported the old phpmyadmin.sql data file and most errors are gone.

Still have the “mcrypt” and “Control User” errors to correct.

Cheers!

TBNK

3

Which version of PHP are you running? The mcrypt extension was deprecated in PHP 7.1 and removed in 7.2, so if you’re running one of those you need a newer version of PHPMyAdmin (assuming that doesn’t need mcrypt anymore).

4

RPK,

php5-mcrypt. I re-installed it and the mcrypt errors went away. Down to a dump of config vars, that are only “warnings”.

Listed those on another help site at:

Cheers!