phpMyAdmin configuration storage

[Nightmare Night]

So I've been trying to enable 2 Factor Authentication to my phpMyAdmin, but due to the limitations within NFO Server's webhosting, I am unable to make the required databases for phpMyAdmin Configuration Storage. Is there by any chance anyone knows a workaround or anything alike?

phpMyAdmin's warning:


Support Member James' explanation on why I had to come to the forums:


phpMyAdmin's documentation on how to setup phpMyAdmin configuration storage


Thanks ahead of time,

Nightmare Night

[Edge100x]

From what you posted, it looks like you just need to enable configuration storage to get past that particular error. From the description of how to use it, it sounds like it is supposed to be enabled by default but that you also may be able to edit config.php.inc and add:

Code: Select all

$cfg['ZeroConf'] = true;

If that doesn't work, then you'd have to go with the manual option, including using their script to import the appropriate tables and setting variables like $cfg['Servers'][$i]['controluser'] and $cfg['Servers'][$i]['controlpass'].

https://docs.phpmyadmin.net/en/latest/s ... ked-tables is the link to the live PMA documentation on this.

[Nightmare Night]

So I'm going to try that first option, but upon looking at my config.inc.php I've found this selection of code within.

Code: Select all

/**
 * phpMyAdmin configuration storage settings.
 */

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma__relation';
// $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
// $cfg['Servers'][$i]['history'] = 'pma__history';
// $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
// $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
// $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
// $cfg['Servers'][$i]['recent'] = 'pma__recent';
// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['users'] = 'pma__users';
// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
// $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
// $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

/**
 * End of servers configuration
 */

Think that if I were to change the "$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';" to a different database, I could override the database it looks at?

EDIT: Turns out adding "$cfg['ZeroConf'] = true;" did not do anything in my benefit within phpMyAdmin

[Nightmare Night]

So I figured it out, but my a tad bit confused on how I did. But I'll try my best to explain it for anyone else who needs help with it.

Basically I uncommented all the code below /* Storage database and tables */ created my own database with my account prefix:
Example:

Code: Select all

$cfg['Servers'][$i]['pmadb'] = 'nfoaccount_phpmyadmin';

then uncommented controluser and controlpass and changed the pma account stuff to my nfo account.
Example:

Code: Select all

$cfg['Servers'][$i]['controluser'] = 'nfoaccount';
$cfg['Servers'][$i]['controlpass'] = 'nfoaccountPassword';

Then after all of this, I was told by phpMyAdmin that the configuration page wasn't correct, then told me to go to the database I created, then go to operations tab, then click the error that generated at the top of the page.