by kendall7858 » 04. June 2014 00:46
Hi All:
I want to sound the trumpets, PRAISE BE TO GOD!
I continually had the following error message upon installing Xampp-Win32-1.8.3-4-VC-11.
$cfg['Servers'][$i]['users'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['usergroups'] ... not OK [ Documentation ]
Configurable menus: Disabled
$cfg['Servers'][$i]['navigationhiding'] ... not OK [ Documentation ]
Hide/show navigation items: Disabled
Quick steps to setup advanced features:
Create the needed tables with the examples/create_tables.sql. Documentation
Create a pma user and give access to these tables. Documentation
Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php. Documentation
Re-login to phpMyAdmin to load the updated configuration file.
I am the type that cannot stand errors. I guess it is a habit. However, I searched high and low for an answer and I found it. The problem lies in the config.inc.php file in phpmyadmin. There is a bit of code missing that configures the tables used in the root/localhost directory. I inserted the following bit of code before the end of the file and it now runs true. If anyone can benefit from this it will make your day. I know it made mine. This needs to be inserted before the end of the file:
/*
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found <<<----------------- Disable warning messages!
*/
$cfg['PmaNoRelation_DisableWarning'] = true;
/*
* phpMyAdmin configuration storage settings. <<<----------------------- Disable all storage features!
*/
//$cfg['Servers'][$i]['controlhost'] = 'localhost';
// MySQL control user settings (this user must have read-only
// access to the "mysql/user" and "mysql/db" tables).
// The controluser is also used for all relational features (pmadb)
//$cfg['Servers'][$i]['controluser'] = '';
// The password needed for the controluser to login
// (see $cfg['Servers'][$i]['controluser'])
//$cfg['Servers'][$i]['controlpass'] = '';
// Database used for Relation, Bookmark and PDF Features
// (see _docdir/examples/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'
//$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'pma_bookmark'
//$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
// table to describe the relation between links (see doc)
// - leave blank for no relation-links support
// DEFAULT: 'pma_relation'
//$cfg['Servers'][$i]['relation'] = 'pma__relation';
// table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'pma_table_info'
//$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
// table to describe the tables position for the PDF schema
// - leave blank for no PDF schema support
// DEFAULT: 'pma_table_coords'
//$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
// table to describe pages of relationpdf
// - leave blank if you don't want to use this
// DEFAULT: 'pma_pdf_pages'
//$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
// table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'pma_column_info'
//$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
// table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'pma_history'
//$cfg['Servers'][$i]['history'] = 'pma__history';
// Table to store user interface enhancement data.
// - Leave blank to disable.
// DEFAULT: 'pma_table_uiprefs'
//$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
// Table to store version/change tracking data
// - leave blank to disable
// DEFAULT: 'pma_tracking'
//$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
// Table in which to store information for the designer feature.
// DEFAULT: 'pma_designer_coords'
//$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
// Table to store user preferences -- allows users to set most
// preferences by themselves and store them in the phpMyAdmin
// configuration storage database.
// If you don't allow for storing preferences in pmadb, users can
// still personalize phpMyAdmin, but settings will be saved in
// browser's local storage, or, it is is unavailable, until the end
// of session.
// DEFAULT: 'pma_userconfig'
//$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
// Table to store a list of recently used tables to be shown in the
// left navigation frame. It helps you to jump across table directly,
// without the need to select the database, and then select the table.
// Using $cfg['LeftRecentTable'] you can configure the maximum number
// of recent tables shown.
// Without configuring the storage, you can still access the recently
// used tables, but it will disappear after you logout.
// DEFAULT: 'pma_recent'
//$cfg['Servers'][$i]['recent'] = 'pma__recent';
// You can create different user groups with menu items attached to them.
// Users can be assigned to these groups and the logged in user
// would only see menu items configured to the usergroup he is assigned to.
// To do this it needs two tables “usergroups” (storing allowed menu items for each user group)
// and “users” (storing users and their assignments to user groups).
// DEFAULT: 'pma_users'
// DEFAULT: 'pma_usergroups'
//$cfg['Servers'][$i]['users'] = 'pma__users';
//$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
// You can hide/show items in the navigation tree.
// DEFAULT: 'pma_navigationhiding'
//$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
/* Contrib / Swekey authentication */
// The name of the file containing Swekey ids and login names for
// hardware authentication. Leave the string empty to deactivate this
// feature.
// see _docdir/examples/swekey.sample.conf
//$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/phpMyAdmin/swekey-pma.conf';
If I can save anyone half the aggravation that I have had searching for this answer, it will render my speachless. I have search high and low to fix this. May God have the glory and peace be unto you.
Kendall