环境:
CentOS 5.5
phpMyAdmin 3.3.6
php 5.2.13
MySQL 5.0.91
Apache 2.2.3
错误信息:链接表的附加功能尚未激活
解决方法:
1.把phpmyadmin目录下scripts/create_tables_mysql_4_1_2+.sql(根据版本选择,如果mysql版本小于4.1.2,就使用create_tables.sql)如果提示错误,可以先导入create_tables.sql,然后再导入一次create_tables_mysql_4_1_2+.sql。
2.将/phpmyadmin/config.inc.php,不存在的话就把config.simple.inc.php拷贝一份,改下名字,将下面一段的注释去掉
$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]['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';
3.将libraries/config.default.php中的$cfg['PmaAbsoluteUri']改为
$cfg['PmaAbsoluteUri'] = 'http://PMA的URL/';
4.清空浏览器缓存重新登陆。