主页 > 整理 | 学习笔记 > phpMyAdmin 高级功能未全部设置,部分功能不可用的解决办法

phpMyAdmin 高级功能未全部设置,部分功能不可用的解决办法

  • 建立一个名为phpmyadmin数据库,导入scripts文件夹下面的create_tables.sql

  • 建立一个相应的用户名,在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';
  • 修改config.inc.php,加入以下内容
/*
 * phpMyAdmin configuration storage settings.
 */

/* User used to manipulate with storage */
$cfg['Servers'][$i]['controluser'] = 'pma'; //pma改为mysql用户名
$cfg['Servers'][$i]['controlpass'] = 'pmapass'; //pmapass改为mysql的密码

/* Storage database and tables */
$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';
/* Contrib / Swekey authentication */
$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';
  • 退出下phpmyadmin,重新登录应该就可以了

发表评论

电子邮件地址不会被公开。 必填项已用*标注