“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 高级功能未全部设置,部分功能不可用”的提示 ???
------解决方案--------------------
不是会有个 要查出原因请点这里。点进去就会有相关的设置提示了 都设置了就不会提示了应该是。
------解决方案--------------------
我很奇怪你那些全角的单引号是从哪里来的,改成半角的再试