使用鏈接表的額外特性尚未激活..修正辦法

經實踐測試,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