phpMyAmin相关问题解决汇总

1、错误:链接表的附加功能尚未激活。要查出原因,请点击此处。

解决方案:
libraries/config.default.php,将$cfg['PmaNoRelation_DisableWarning']的值改为ture。(只此一步即可解决)
分别修改:
$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]['designer_coords'] = ”;
修改为:
$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’
$cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;

 

2、phpmyadmin中配置文件现在需要绝密的短语密码

vi phpmyadmin/config.inc.php

<?php
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['blowfish_secret'] = 'bobo365';(其中的"bobo365"自定义)
?

 

 

3、进行代码调试时,修改php.ini文件,列出错误信息,重启apache后生效。

加入如下代码:

error_reporting = E_ALL & ~E_NOTICE