Тема: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

Здравствуйте я знаю что такая тема у же есть но у меня не получается настроить
при входе выдает внизу
Дополнительные возможности phpMyAdmin не настроены в полной мере, некоторые функции были отключены. Для определения причины нажмите здесь.
http://s018.radikal.ru/i514/1411/6e/eeac4aae95ac.png
нажимаю здесь и появляется
http://s008.radikal.ru/i305/1411/94/da2c0ff7ec7d.png
http://i038.radikal.ru/1411/78/ea25cd28f0f2.png
в etc/phpMyAdmin/config.inc.php  вот что у меня

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use setup/
 *
 * All directives are explained in documentation in the doc/ folder
 * or at <http://docs.phpmyadmin.net/>.
 *
 * @package PhpMyAdmin
 */

/* 
 * Your phpMyAdmin url
 *
 * Complete the variable below with the full url ie
 *    https://www.your_web.net/path_to_your_phpMyAdmin_directory/
 *
 * It must contain characters that are valid for a URL, and the path is
 * case sensitive on some Web servers, for example Unix-based servers.
 *
 * In most cases you can leave this variable empty, as the correct value
 * will be detected automatically. However, we recommend that you do
 * test to see that the auto-detection code works in your system. A good
 * test is to browse a table, then edit a row and save it.  There will be
 * an error message if phpMyAdmin cannot auto-detect the correct value.
 *
 * If the auto-detection code does work properly, you can set to true the
 * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
 */
$cfg['PmaAbsoluteUri'] = '';

/*
 * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
 * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
 * works perfectly.
 */
$cfg['PmaAbsoluteUri_DisableWarning'] = false;

/*
 * 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
 */
$cfg['PmaNoRelation_DisableWarning']  = false;

/*
 * Disable the default warning that is displayed if Suhosin is detected
 *
 * @global boolean $cfg['SuhosinDisableWarning']
 */
$cfg['SuhosinDisableWarning'] = true;

/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = '4f2sdgf1DF354fdds4dfFD42s21vb5x41fdgdfg6s4jghkbndDd'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;
// MySQL hostname or IP address
$cfg['Servers'][$i]['host']                = 'localhost';

// MySQL port - leave blank for default port
$cfg['Servers'][$i]['port']                = '';

// Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['socket']              = '';

// Use SSL for connecting to MySQL server?
$cfg['Servers'][$i]['ssl']                 = false;

// How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['connect_type']        = 'socket';

// The PHP MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['extension']           = 'mysqli';

// Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['compress']            = false;

// Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['auth_type']           = 'cookie';

// MySQL user
$cfg['Servers'][$i]['user']                = 'root';

// MySQL password (only needed with 'config' auth_type)
$cfg['Servers'][$i]['password']            = '';

// Allow access without password
$cfg['Servers'][$i]['AllowNoPassword']     = false;

// whether to allow root login
$cfg['Servers'][$i]['AllowRoot']           = true;

// Session to use for 'signon' authentication method
$cfg['Servers'][$i]['SignonSession']       = '';

// URL where to redirect user to login for 'signon' authentication method
$cfg['Servers'][$i]['SignonURL']           = '';

// URL where to redirect user after logout
$cfg['Servers'][$i]['LogoutURL']           = '';

// If set to a db-name, only this db is displayed in left frame
// It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['only_db']             = '';

// Verbose name for this host - leave blank to show the hostname
$cfg['Servers'][$i]['verbose']             = '';

// set to false if you know that your pma_* tables
// are up to date. This prevents compatibility
// checks and thereby increases performance.
$cfg['Servers'][$i]['verbose_check']       = true;

// Host authentication order, leave blank to not use
$cfg['Servers'][$i]['AllowDeny']['order']  = '';

// Host authentication rules, leave blank for defaults
$cfg['Servers'][$i]['AllowDeny']['rules']  = array();
 
/*
 * phpMyAdmin configuration storage settings.
 */
$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';

// 
$cfg['Servers'][$i]['savedsearches']       = 'pma__savedsearches';

/* 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';


/***************************************
 * Second Server
 */

/*
$i++;
$cfg['Servers'][$i]['host']                = 'localhost';
$cfg['Servers'][$i]['port']                = '';
$cfg['Servers'][$i]['socket']              = '';
$cfg['Servers'][$i]['ssl']                 = false;
$cfg['Servers'][$i]['connect_type']        = 'socket';
$cfg['Servers'][$i]['extension']           = 'mysqli';
$cfg['Servers'][$i]['compress']            = false;
$cfg['Servers'][$i]['auth_type']           = 'cookie';
$cfg['Servers'][$i]['user']                = 'root';
$cfg['Servers'][$i]['password']            = '';
$cfg['Servers'][$i]['AllowNoPassword']     = false;
$cfg['Servers'][$i]['AllowRoot']           = true;
$cfg['Servers'][$i]['SignonSession']       = '';
$cfg['Servers'][$i]['SignonURL']           = '';
$cfg['Servers'][$i]['LogoutURL']           = '';
$cfg['Servers'][$i]['only_db']             = '';
$cfg['Servers'][$i]['verbose']             = '';
$cfg['Servers'][$i]['verbose_check']       = true;
$cfg['Servers'][$i]['AllowDeny']['order']  = '';
$cfg['Servers'][$i]['AllowDeny']['rules']  = array();
*/
 
/*
 * phpMyAdmin configuration storage settings.
 */


$cfg['Servers'][$i]['controlhost']         = 'localhost';
$cfg['Servers'][$i]['controluser']         = 'root';
$cfg['Servers'][$i]['controlpass']         = 'No#FNhI';
$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_cords';
$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]['designer_coords']     = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig']          = 'pma__userconfig';
$cfg['Servers'][$i]['recent']              = 'pma__recent';
$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]['auth_swekey_config']  = '/etc/phpMyAdmin/swekey-pma_02.conf';


// If you have more than one server configured, you can set $cfg['ServerDefault']
// to any one of them to autoconnect to that server when phpMyAdmin is started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfg['ServerDefault'] *MUST* be
// set to that server.

// Default server (0 = no default server)
$cfg['ServerDefault'] = 1;
$cfg['Server']        = '0';
unset($cfg['Servers'][0]);

/*
 * End of servers configuration
 ****************************************/


/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

/**
 * Whether to display icons or text or both icons and text in table row
 * action segment. Value can be either of 'icons', 'text' or 'both'.
 */
//$cfg['RowActionType'] = 'both';

/**
 * Defines whether a user should be displayed a "show all (records)"
 * button in browse mode or not.
 * default = false
 */
//$cfg['ShowAll'] = true;

/**
 * Number of rows displayed when browsing a result set. If the result
 * set contains more rows, "Previous" and "Next".
 * default = 30
 */
//$cfg['MaxRows'] = 50;

/**
 * disallow editing of binary fields
 * valid values are:
 *   false    allow editing
 *   'blob'   allow editing except for BLOB fields
 *   'noblob' disallow editing except for BLOB fields
 *   'all'    disallow editing
 * default = blob
 */
//$cfg['ProtectBinary'] = 'false';

/**
 * Default language to use, if not browser-defined or user-defined
 * (you find all languages in the locale folder)
 * uncomment the desired line:
 * default = 'en'
 */
//$cfg['DefaultLang'] = 'en';
//$cfg['DefaultLang'] = 'de';

/**
 * default display direction (horizontal|vertical|horizontalflipped)
 */
//$cfg['DefaultDisplay'] = 'vertical';


/**
 * How many columns should be used for table display of a database?
 * (a value larger than 1 results in some information being hidden)
 * default = 1
 */
//$cfg['PropertiesNumColumns'] = 2;

/**
 * Set to true if you want DB-based query history.If false, this utilizes
 * JS-routines to display query history (lost by window close)
 *
 * This requires configuration storage enabled, see above.
 * default = false
 */
//$cfg['QueryHistoryDB'] = true;

/**
 * When using DB-based query history, how many entries should be kept?
 *
 * default = 25
 */
//$cfg['QueryHistoryMax'] = 100;

/**
 * Should error reporting be enabled for JavaScript errors
 *
 * default = 'ask'
 */
//$cfg['SendErrorReports'] = 'ask';

/*
 * You can find more configuration options in the documentation
 * in the doc/ folder or at <http://docs.phpmyadmin.net/>.
 */
?>

Помогите пожалуйста

2

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

У вас указана база данных расширений с именем phpmyadmin. В списке этой базы данных не видно. Создайте ее и импортируйте таблицы расширений. Смотрите здесь: http://php-myadmin.ru/learning/instrument-pma.html

3

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

Hanut сказал:

У вас указана база данных расширений с именем phpmyadmin. В списке этой базы данных не видно. Создайте ее и импортируйте таблицы расширений. Смотрите здесь: http://php-myadmin.ru/learning/instrument-pma.html

сделал вот что получается http://s018.radikal.ru/i511/1411/f2/abe116ed7f0e.png

4

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

Hanut сказал:

У вас указана база данных расширений с именем phpmyadmin. В списке этой базы данных не видно. Создайте ее и импортируйте таблицы расширений. Смотрите здесь: http://php-myadmin.ru/learning/instrument-pma.html

теперь вот в config.inc.php как я понимая нужно добавить pma пользователя и пароль я добавил но ошибка всё равно не исчезает

5

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

у меня у пользователя pma почему то в колонке предоставить (нет) это нормально
http://s018.radikal.ru/i520/1411/f1/0b7c7f3101a8.png

6

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

с проблемой справился но не до конца http://s61.radikal.ru/i171/1411/2f/a63912a0ce2b.png

7

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

Проверьте соответствие имен таблиц. Вижу на втором сервере имя с ошибкой pma__table_cords.

8

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

Hanut сказал:

Проверьте соответствие имен таблиц. Вижу на втором сервере имя с ошибкой pma__table_cords.

а вы бы не могли подсказать как это сделать

9

Re: Ошибка Дополнительные возможности phpMyAdmin не настроены в полной мер

всё спасибо ошибку нашел исправил вот если кому надо

    

    <?php
    /* vim: set expandtab sw=4 ts=4 sts=4: */
    /**
     * phpMyAdmin sample configuration, you can use it as base for
     * manual configuration. For easier setup you can use setup/
     *
     * All directives are explained in documentation in the doc/ folder
     * or at <http://docs.phpmyadmin.net/>.
     *
     * @package PhpMyAdmin
     */
     
    /*
     * Your phpMyAdmin url
     *
     * Complete the variable below with the full url ie
     *    https://www.your_web.net/path_to_your_phpMyAdmin_directory/
     *
     * It must contain characters that are valid for a URL, and the path is
     * case sensitive on some Web servers, for example Unix-based servers.
     *
     * In most cases you can leave this variable empty, as the correct value
     * will be detected automatically. However, we recommend that you do
     * test to see that the auto-detection code works in your system. A good
     * test is to browse a table, then edit a row and save it.  There will be
     * an error message if phpMyAdmin cannot auto-detect the correct value.
     *
     * If the auto-detection code does work properly, you can set to true the
     * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
     */
    $cfg['PmaAbsoluteUri'] = '';
     
    /*
     * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
     * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
     * works perfectly.
     */
    $cfg['PmaAbsoluteUri_DisableWarning'] = false;
     
    /*
     * 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
     */
    $cfg['PmaNoRelation_DisableWarning']  = false;
     
    /*
     * Disable the default warning that is displayed if Suhosin is detected
     *
     * @global boolean $cfg['SuhosinDisableWarning']
     */
    $cfg['SuhosinDisableWarning'] = true;
     
    /*
     * This is needed for cookie based authentication to encrypt password in
     * cookie
     */
    $cfg['blowfish_secret'] = '4f2sdgf1DF354fdds4dfFD42s21vb5x41fdgdfg6s4jghkbndDd'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
     
    /*
     * Servers configuration
     */
    $i = 0;
     
    /*
     * First server
     */
    $i++;
    // MySQL hostname or IP address
    $cfg['Servers'][$i]['host']                = 'localhost';
     
    // MySQL port - leave blank for default port
    $cfg['Servers'][$i]['port']                = '';
     
    // Path to the socket - leave blank for default socket
    $cfg['Servers'][$i]['socket']              = '';
     
    // Use SSL for connecting to MySQL server?
    $cfg['Servers'][$i]['ssl']                 = false;
     
    // How to connect to MySQL server ('tcp' or 'socket')
    $cfg['Servers'][$i]['connect_type']        = 'socket';
     
    // The PHP MySQL extension to use ('mysql' or 'mysqli')
    $cfg['Servers'][$i]['extension']           = 'mysqli';
     
    // Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
    $cfg['Servers'][$i]['compress']            = false;
     
    // Authentication method (config, http or cookie based)?
    $cfg['Servers'][$i]['auth_type']           = 'cookie';
     
    // MySQL user
    $cfg['Servers'][$i]['user']                = 'root';
     
    // MySQL password (only needed with 'config' auth_type)
    $cfg['Servers'][$i]['password']            = '';
     
    // Allow access without password
    $cfg['Servers'][$i]['AllowNoPassword']     = false;
     
    // whether to allow root login
    $cfg['Servers'][$i]['AllowRoot']           = true;
     
    // Session to use for 'signon' authentication method
    $cfg['Servers'][$i]['SignonSession']       = '';
     
    // URL where to redirect user to login for 'signon' authentication method
    $cfg['Servers'][$i]['SignonURL']           = '';
     
    // URL where to redirect user after logout
    $cfg['Servers'][$i]['LogoutURL']           = '';
     
    // If set to a db-name, only this db is displayed in left frame
    // It may also be an array of db-names, where sorting order is relevant.
    $cfg['Servers'][$i]['only_db']             = '';
     
    // Verbose name for this host - leave blank to show the hostname
    $cfg['Servers'][$i]['verbose']             = '';
     
    // set to false if you know that your pma_* tables
    // are up to date. This prevents compatibility
    // checks and thereby increases performance.
    $cfg['Servers'][$i]['verbose_check']       = true;
     
    // Host authentication order, leave blank to not use
    $cfg['Servers'][$i]['AllowDeny']['order']  = '';
     
    // Host authentication rules, leave blank for defaults
    $cfg['Servers'][$i]['AllowDeny']['rules']  = array();
     
    /*
     * phpMyAdmin configuration storage settings.
     */
    $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']         = 'pma';
     
    // 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';
     
    //
    $cfg['Servers'][$i]['savedsearches']       = 'pma__savedsearches';
     
    /* 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';
     
     
    /***************************************
     * Second Server
     */
     
    /*
    $i++;
    $cfg['Servers'][$i]['host']                = 'localhost';
    $cfg['Servers'][$i]['port']                = '';
    $cfg['Servers'][$i]['socket']              = '';
    $cfg['Servers'][$i]['ssl']                 = false;
    $cfg['Servers'][$i]['connect_type']        = 'socket';
    $cfg['Servers'][$i]['extension']           = 'mysqli';
    $cfg['Servers'][$i]['compress']            = false;
    $cfg['Servers'][$i]['auth_type']           = 'cookie';
    $cfg['Servers'][$i]['user']                = 'root';
    $cfg['Servers'][$i]['password']            = '';
    $cfg['Servers'][$i]['AllowNoPassword']     = false;
    $cfg['Servers'][$i]['AllowRoot']           = true;
    $cfg['Servers'][$i]['SignonSession']       = '';
    $cfg['Servers'][$i]['SignonURL']           = '';
    $cfg['Servers'][$i]['LogoutURL']           = '';
    $cfg['Servers'][$i]['only_db']             = '';
    $cfg['Servers'][$i]['verbose']             = '';
    $cfg['Servers'][$i]['verbose_check']       = true;
    $cfg['Servers'][$i]['AllowDeny']['order']  = '';
    $cfg['Servers'][$i]['AllowDeny']['rules']  = array();
    */
     
    /*
     * phpMyAdmin configuration storage settings.
     */
     
     
    $cfg['Servers'][$i]['controlhost']         = 'localhost';
    $cfg['Servers'][$i]['controluser']         = 'pma';
    $cfg['Servers'][$i]['controlpass']         = '***';
    $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]['designer_coords']     = 'pma__designer_coords';
    $cfg['Servers'][$i]['userconfig']          = 'pma__userconfig';
    $cfg['Servers'][$i]['recent']              = 'pma__recent';
    $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]['auth_swekey_config']  = '/etc/phpMyAdmin/swekey-pma_02.conf';
     
     
    // If you have more than one server configured, you can set $cfg['ServerDefault']
    // to any one of them to autoconnect to that server when phpMyAdmin is started,
    // or set it to 0 to be given a list of servers without logging in
    // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
    // set to that server.
     
    // Default server (0 = no default server)
    $cfg['ServerDefault'] = 1;
    $cfg['Server']        = '0';
    unset($cfg['Servers'][0]);
     
    /*
     * End of servers configuration
     ****************************************/
     
     
    /*
     * Directories for saving/loading files from server
     */
    $cfg['UploadDir'] = '';
    $cfg['SaveDir'] = '';
     
    /**
     * Whether to display icons or text or both icons and text in table row
     * action segment. Value can be either of 'icons', 'text' or 'both'.
     */
    //$cfg['RowActionType'] = 'both';
     
    /**
     * Defines whether a user should be displayed a "show all (records)"
     * button in browse mode or not.
     * default = false
     */
    //$cfg['ShowAll'] = true;
     
    /**
     * Number of rows displayed when browsing a result set. If the result
     * set contains more rows, "Previous" and "Next".
     * default = 30
     */
    //$cfg['MaxRows'] = 50;
     
    /**
     * disallow editing of binary fields
     * valid values are:
     *   false    allow editing
     *   'blob'   allow editing except for BLOB fields
     *   'noblob' disallow editing except for BLOB fields
     *   'all'    disallow editing
     * default = blob
     */
    //$cfg['ProtectBinary'] = 'false';
     
    /**
     * Default language to use, if not browser-defined or user-defined
     * (you find all languages in the locale folder)
     * uncomment the desired line:
     * default = 'en'
     */
    //$cfg['DefaultLang'] = 'en';
    //$cfg['DefaultLang'] = 'de';
     
    /**
     * default display direction (horizontal|vertical|horizontalflipped)
     */
    //$cfg['DefaultDisplay'] = 'vertical';
     
     
    /**
     * How many columns should be used for table display of a database?
     * (a value larger than 1 results in some information being hidden)
     * default = 1
     */
    //$cfg['PropertiesNumColumns'] = 2;
     
    /**
     * Set to true if you want DB-based query history.If false, this utilizes
     * JS-routines to display query history (lost by window close)
     *
     * This requires configuration storage enabled, see above.
     * default = false
     */
    //$cfg['QueryHistoryDB'] = true;
     
    /**
     * When using DB-based query history, how many entries should be kept?
     *
     * default = 25
     */
    //$cfg['QueryHistoryMax'] = 100;
     
    /**
     * Should error reporting be enabled for JavaScript errors
     *
     * default = 'ask'
     */
    //$cfg['SendErrorReports'] = 'ask';
     
    /*
     * You can find more configuration options in the documentation
     * in the doc/ folder or at <http://docs.phpmyadmin.net/>.
     */
    ?>