在phpmyadmin主页的页脚上有一条警告信息,内容是:"用于操作链接表格的附加功能已经被禁用。要了解原因,请点击此处。"。
尝试一下这个SQL
,它来自于phpAdmin文档(链接表主题):
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配置存储以从许多有趣的功能中受益。请参见http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage。
每次升级phpMyAdmin版本时都会出现此警告。
对于Ubuntu用户,请在这里找到解决方案: