安装了phpmyadmin,登录后,显示错误信息“链接表的额外特性尚未激活问题”,网上查询,解决办法是先建个名为”phpmyadmin”的数据库,再将scripts/create_tables.sql导入,最后将config.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]['designer_coords'] = ‘pma_designer_coords’; 但按如上操作后,依然出现“链接表的额外特性尚未激活”的提示,网上也找不到其它的解决办法。 经研究后,发现是需要将config.inc.php中的['controluser']和['controlpass']按如下显示方式设置: $cfg['Servers'][$i]['controluser']=’pma’; $cfg['Servers'][$i]['controlpass']=’pmapass’; 其中,pma和pmapass可改为对’phpmyadmin’数据库有权限的MySQL的帐户名和帐户密码。 如果要使用pma和pmapass的话,需新建个’pma’帐户。在创建了’phpmyadmin‘数据库之后,执行如下SQL语句即可。 ?View Code MYSQLGRANT USAGE ON mysql.* TO ‘pma’@'localhost’ IDENTIFIED BY ‘pmapass’; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, [...]
Tagged mysql, PHP, phpmyadmin