“phpMyAdmin 高级效能未全部设置，部分功能不可用。要查出原因请点这里。”

程序员文章站 2024-02-06 09:43:22

...

“phpMyAdmin 高级功能未全部设置，部分功能不可用。要查出原因请点这里。”
配置好phpmyadmin 登陆后，总提示　“phpMyAdmin 高级功能未全部设置，部分功能不可用。要查出原因请点这里。”

我按照下面方法解决

通过SQL文件phpmyadmin/script/create_tables.sql 创建数据表phpmyadmin。直接使用phpmyadmin导入功能。

再建立一个相应的用户名，在phpmyadmin的sql查询功能框中输入SQL代码：
GRANT USAGE ON mysql.* TO ‘pma’@'localhost’ IDENTIFIED BY ‘pmapass’;
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO ‘pma’@'localhost’;
GRANT SELECT ON mysql.db TO ‘pma’@'localhost’;
GRANT SELECT ON mysql.host TO ‘pma’@'localhost’;
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO ‘pma’@'localhost’;

在phpmyadmin所在根目录的config.inc.php加入如下代码：

$cfg['Servers'][$i]['controluser'] = ‘pma’;
$cfg['Servers'][$i]['controlpass'] = ‘pmapass’;

$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]['userconfig'] = ‘pma_userconfig’;

以上配置后，为什么仍然出现　“phpMyAdmin 高级功能未全部设置，部分功能不可用”的提示　？？？

------解决方案--------------------
不是会有个要查出原因请点这里。点进去就会有相关的设置提示了都设置了就不会提示了应该是。
------解决方案--------------------
我很奇怪你那些全角的单引号是从哪里来的，改成半角的再试