关于使用phpadmin链接表的额外特性尚未激活的解决办法

"使用链接表的额外特性尚未激活.."修正办法!  
    在使用了新的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'

  
这样保存后刷新页面就好了``

 

blowfish_secret'用一个任意字符串作为cookie的加密字符串，如果没有加密钥匙,系统会显示"配置文件现在需要绝密的短语密码(blowfish_secret) " ,配置如下:
vi phpmyadmin/config.inc.php
<?php
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['blowfish_secret'] = 'sakia';（其中的"sakia"自定义）
?>
修改以后，以后登入phpmyadmin就方便多了，但一定不要使用空密码，切记！