点击这里给我发消息 点击这里给我发消息
首页 > 行业资讯 > MSSQL>详细内容

"使用链接表的额外特性尚未激活.."修正办

添加时间:2013-12-6
    相关阅读: 页面 数据库 Windows 链接

经实践测试,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 ;
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中有三组,只要把第一组更改即可.)
 

 

本文作者:
咨询热线:020-85648757 85648755 85648616 0755-27912581 客服:020-85648756 0755-27912581 业务传真:020-32579052
广州市网景网络科技有限公司 Copyright◎2003-2008 Veelink.com. All Rights Reserved.
广州商务地址:广东省广州市黄埔大道中203号(海景园区)海景花园C栋501室
= 深圳商务地址:深圳市宝源路华丰宝源大厦606
研发中心:广东广州市天河软件园海景园区 粤ICP备05103322号 工商注册