php PhpMyAdmin 配置文件错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13408281/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PhpMyAdmin error with config file
提问by Dave
Errors are:
错误是：
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
Server running with Suhosin. Please refer to documentation for possible issues.$cfg['Servers'][$i]['pmadb'] ... OK
$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
General relation features: Disabled$cfg['Servers'][$i]['table_info'] ... not OK [ Documentation ]
Display Features: Disabled$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ... not OK [ Documentation ]
Creation of PDFs: Disabled$cfg['Servers'][$i]['column_info'] ...not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled$cfg['Servers'][$i]['bookmarktable'] ... not OK [ Documentation ]
Bookmarked SQL query: Disabled$cfg['Servers'][$i]['history'] ...not OK [ Documentation ]
SQL history: Disabled$cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ]
Designer: Disabled$cfg['Servers'][$i]['tracking'] ... not OK [ Documentation ]
Tracking: Disabled$cfg['Servers'][$i]['userconfig'] ... not OK [ Documentation ]
User preferences: Disabled
phpMyAdmin 配置存储未完全配置，一些扩展功能已停用。要了解原因，请单击此处。
使用 Suhosin 运行的服务器。请参阅文档以了解可能的问题。$cfg['Servers'][$i]['pmadb'] ...好的
$cfg['Servers'][$i]['relation'] ... 不行 [文档]
一般关系特性：禁用$cfg['Servers'][$i]['table_info'] ... 不行 [文档]
显示功能：禁用$cfg['Servers'][$i]['table_coords'] ... 不好 [文档]
$cfg['Servers'][$i]['pdf_pages'] ... 不行 [文档]
创建 PDF：已禁用$cfg['Servers'][$i]['column_info'] ...不行 [文档]
显示列注释：已禁用
浏览器转换：已禁用$cfg['Servers'][$i]['bookmarktable'] ... 不行 [文档]
书签 SQL 查询：已禁用$cfg['Servers'][$i]['history'] ...不行 [文档]
SQL 历史：禁用$cfg['Servers'][$i]['designer_coords'] ... 不行 [文档]
设计师：已禁用$cfg['Servers'][$i]['tracking'] ... 不行 [文档]
跟踪：已禁用$cfg['Servers'][$i]['userconfig'] ... 不行 [文档]
用户首选项：禁用
My config.inc.php file is as follows:
我的 config.inc.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.html and on phpMyAdmin
* wiki <http://wiki.phpmyadmin.net>.
*
* @package phpMyAdmin
*/
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'myblowfishpass';
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/*
* phpMyAdmin configuration storage settings.
*/
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controluser'] = 'dave1';
$cfg['Servers'][$i]['controlpass'] = 'mypassword';
/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'wordpress_db'; //the name of my db table
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; //does the pma_ need to change to dave1_?
$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]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
/* Contrib / Swekey authentication */
$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';
/*
* End of servers configuration
*/
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
/**
* 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;
/**
* Use graphically less intense menu tabs
* default = false
*/
//$cfg['LightTabs'] = true;
/**
* disallow editing of binary fields
* valid values are:
* false allow editing
* 'blob' allow 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;
/*
* You can find more configuration options in Documentation.html
* or here: http://wiki.phpmyadmin.net/pma/Config
*/
回答by Tejesh Alimilli
I too had this same problem. clearing cookies and cache worked for me. try it
我也有同样的问题。清除 cookie 和缓存对我有用。尝试一下
回答by Jef888
If you are using "create_tables.sql" to create the database and tables, change the tables name pma__to pma_. (change 2 underscore to 1 underscore)
如果您使用“create_tables.sql”来创建数据库和表，请将表名称更改pma__为pma_. （将 2 个下划线更改为 1 个下划线）
Or change the tables name in "config.inc.php", pma_to pma__(change 1 underscore to 2 underscore).
For example, pma_bookmarkto pma__bookmark
或者将“config.inc.php”中的表名称更改pma_为pma__（将 1 个下划线更改为 2 个下划线）。
例如，pma_bookmark到pma__bookmark
$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]['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]['table_uiprefs'] = 'pma__table_uiprefs';
回答by Pavel Galkin
VestaCP Team made and successfully tested error fixer for phpMyAdmin (no more annoying message "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated"). We hope that fix will be useful and will help users.
VestaCP 团队为 phpMyAdmin 制作并成功测试了错误修复程序（不再出现烦人的消息“phpMyAdmin 配置存储未完全配置，一些扩展功能已被停用”）。我们希望修复将是有用的，并会帮助用户。
Page on Github: https://github.com/skurudo/phpmyadmin-fixer
Github 页面：https: //github.com/skurudo/phpmyadmin-fixer
What the script does:
脚本的作用：
- works from user root;
- changes inside /etc/phpmyadmin/config.inc.php, fixes value;
- makes a backup of /etc/phpmyadmin/config.inc.php in /root folder; adds in a mysql pma user / and the table phpmyadmin (if the user "pma" or the table "phpmyadmin" already exists, the script will delete those!);
- download and add table for database phpmyadmin;
- clean temp files, leftover pma.txt (contains password for pma@localhost) and old config;
- 从用户根工作；
- /etc/phpmyadmin/config.inc.php 中的更改，修复了值；
- 在/root文件夹中备份/etc/phpmyadmin/config.inc.php；添加一个mysql pma user / 和表phpmyadmin（如果用户“pma”或表“phpmyadmin”已经存在，脚本将删除它们！）；
- 为数据库phpmyadmin下载并添加表；
- 清理临时文件、剩余的 pma.txt（包含 pma@localhost 的密码）和旧配置；
回答by 000
$cfg['Servers'][$i]['user'] = 'root'; //mysql username here
$cfg['Servers'][$i]['password'] = 'password'; //mysql password here
Try adding the above configuration lines after $cfg['Servers'][$i]['connect_type'] = 'tcp';
尝试在之后添加上面的配置行 $cfg['Servers'][$i]['connect_type'] = 'tcp';
If these also doesn't work then try with a fresh configuration file, may be by copying config.sample.inc.php. Do ensure that it has the above mentioned configuration lines. Check that if it works fine and then start making changes to it step by step, if any changes are to be made..
如果这些也不起作用，那么尝试使用新的配置文件，可能是通过复制config.sample.inc.php。请确保它具有上述配置行。检查它是否工作正常，然后开始逐步对其进行更改，如果要进行任何更改..
Please note that the username and password you provide should be able to login you from mysql command prompt..
请注意，您提供的用户名和密码应该能够从 mysql 命令提示符登录。
回答by Dylan B
Please follow these steps :
请按照以下步骤操作：
- Create a database named phpmyadmin Import database sql/create_tables.sql
- Create a user and Grant access for a user to that database (GRANT ALL PRIVILEGES ON phpmyadmin.* TO user@'localhost' IDENTIFIED BY 'password';)
Locate and edit your config file, enable these lines in your config.inc.php (remove # in front of each lines)
/* User used to manipulate with storage */ $cfg['Servers'][$i]['controlhost'] = 'localhost'; $cfg['Servers'][$i]['controluser'] = 'phpmyadmin_pma'; $cfg['Servers'][$i]['controlpass'] = 'yourpassword'; /* 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]['designer_coords'] = 'pma__designer_coords'; $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; $cfg['Servers'][$i]['recent'] = 'pma__recent'; /* These lines I added-in because they are not exist in the config_sample.inc.php */ $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';
- 创建一个名为 phpmyadmin 的数据库 导入数据库 sql/create_tables.sql
- 创建一个用户并授予用户对该数据库的访问权限（GRANT ALL PRIVILEGES ON phpmyadmin.* TO user@'localhost' IDENTIFIED BY 'password';）
找到并编辑您的配置文件，在 config.inc.php 中启用这些行（删除每行前面的 #）
/* User used to manipulate with storage */ $cfg['Servers'][$i]['controlhost'] = 'localhost'; $cfg['Servers'][$i]['controluser'] = 'phpmyadmin_pma'; $cfg['Servers'][$i]['controlpass'] = 'yourpassword'; /* 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]['designer_coords'] = 'pma__designer_coords'; $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; $cfg['Servers'][$i]['recent'] = 'pma__recent'; /* These lines I added-in because they are not exist in the config_sample.inc.php */ $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';
Please note there are two underscores in between pma__ , you need to make sure it is matched the table name in your database
请注意 pma__ 之间有两个下划线，您需要确保它与数据库中的表名匹配
IF you see this error: $cfg['Servers'][$i]['userconfig'] ... not OK [ Documentation ] User preferences: Disabled
如果您看到此错误： $cfg['Servers'][$i]['userconfig'] ... 不行 [文档] 用户首选项：已禁用
That means your configuration setting is not matched the table's name, or... your user does not have access to the database.
这意味着您的配置设置与表的名称不匹配，或者...您的用户无权访问数据库。
回答by Houssin Boulla
to correct the error, click on the message, after that on top you can si link create, click on create and refresh. this solution work with me.
要更正错误，请单击消息，然后在顶部您可以创建链接，单击创建并刷新。这个解决方案对我有用。
回答by Ioannis Chrysochos
1) Check if you have phpmyadmin database in your mysql server. Phpmyadmin helps you create its database.
1) 检查您的 mysql 服务器中是否有 phpmyadmin 数据库。phpmyadmin 帮助您创建它的数据库。
2) Check if you have pma user. If not create it:
2) 检查您是否有 pma 用户。如果没有创建它：
CREATE USER 'pma'@'localhost' IDENTIFIED BY 'yourPassword';
The pma password must be the same as the one given in config.inc.php
pma 密码必须与 config.inc.php 中给出的密码相同
3) Give privileges to pma:
3) 给 pma 权限：
GRANT ALL PRIVILEGES ON phpmyadmin.* TO `pma`@`localhost` WITH GRANT OPTION;
FLUSH PRIVILEGES;
4) Clear cache and cookies.
4）清除缓存和cookies。
回答by Anh Nguyen
Right in the error page, if you scroll down to the bottom. There is a tip telling you to log out and log in again. Doing this will work
就在错误页面中，如果您向下滚动到底部。有一个提示告诉您注销并重新登录。这样做会奏效
