"使用链接表的额外特性尚未激活.."修正办_MySQL
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了"使用链接表的额外特性尚未激活.."修正办_MySQL,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3102字,纯文字阅读大概需要5分钟。
内容图文
经实践测试,config.inc.php中有三组,只要把第一组更改即可.是否多了额外的特性?自己再细心研究"使用链接表的额外特性尚未激活.."修正办法!
在使用了新的phpmyadmin (2.6.0-beta*或者更高版本) 来管理mysql后,你每打开一个库的时候,会看到这么一句:
错误
使用链接表的额外特性尚未激活。要查出原因,请单击此处。
单击了所谓的此处后,会跳到一个页面显示:
PMA Database ... 不好[ 文档 ]
一般关系特性 已禁用
/再点文档,就有关于这新特性说明了.
大概是英文,我读得也只是略懂.论坛上看到有朋友问,就开始解决它!
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you need special tables with a predefined structure, which we explain below.
See the Quick Install section in this document for a quick way of creating those tables. Also, if you are using a Windows server, read FAQ 1.23.
If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb'].
If you are setting up a multi-user phpMyAdmin installation, you will need to create a new database and setup special privileges, so, as superuser:
create a new database for phpMyAdmin:
CREATE DATABASE phpmyadmin;
Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser):
GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost';
do not give any other user rights on this database.
enter the database name in $cfg['Servers'][$i]['pmadb']
我是这样做的:
1.先建立一个名为phpmyadmin的数据库
2.然后把目录下scripts/create_tables.sql导入到这个库, mysqldir/bin/mysql -u root -p /phpadmin_dir/scripts/create_tables.sql
3.打开config.inc.php配置文件.
找到以下这些,把//后面的东西加在 ' ' 里.......注意,你也许能找到三个或者更多类似的内容,一起改吧.
$cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$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]['pmadb'] = 'phpmyadmin'; // 'phpmyadmin' - see scripts/create_tables.sql
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // 'pma_bookmark'
$cfg['Servers'][$i]['relation'] = 'pma_relation'; // 'pma_relation'
$cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // 'pma_table_info'
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // 'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // 'pma_pdf_pages'
$cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // 'pma_column_info'
$cfg['Servers'][$i]['history'] = 'pma_history'; // 'pma_history'
保存文件,再刷新你的页面.没有错误提示了吧
(经实践测试,config.inc.php中有三组,只要把第一组更改即可.)
内容总结
以上是互联网集市为您收集整理的"使用链接表的额外特性尚未激活.."修正办_MySQL全部内容,希望文章能够帮你解决"使用链接表的额外特性尚未激活.."修正办_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。