phpMyAdmin 配置存储未完全配置 [英] phpMyAdmin configuration storage is not completely configured

问题描述

我已经在 Windows 上安装了 xampp 5.6.14.我打开 phpmyadmin http://localhost/phpmyadmin/

但是警告

<块引用>

！phpMyAdmin配置存储没有完全配置好，一些扩展功能已被停用.找出为什么.或者，也可以转到任何数据库的操作"选项卡进行设置.

！您以没有密码的root"身份连接，这对应于默认 MySQL 特权帐户.您的 MySQL 服务器正在运行这个默认设置对入侵开放，你真的应该解决这个问题通过为用户root"设置密码来解决安全漏洞.

如何解决?

更新:我在 PMA 数据库中看到我的问题......在 phpMyAdmin 升级中不行 但我不明白.当我通过 phpmyadmin 中的 sql 查询在create_tables.sql"中创建包含内容的数据库时，出现错误

如果不存在则创建表`pma_users`(`username` varchar(64) NOT NULL,`usergroup` varchar(64) 非空，主键(`用户名`，`用户组`))COMMENT='用户及其对用户组的分配'默认字符集 utf8 整理 utf8_bin;如果不存在则创建表`pma_usergroups`(`usergroup` varchar(64) 非空，`tab` varchar(64) 非空，`allowed` enum('Y','N') NOT NULL DEFAULT 'N',PRIMARY KEY (`usergroup`,`tab`,`allowed`))COMMENT='具有配置菜单项的用户组'默认字符集 utf8 整理 utf8_bin;如果不存在则创建表`pma_navigationhiding`(`username` varchar(64) NOT NULL,`item_name` varchar(64) 非空，`item_type` varchar(64) 非空，`db_name` varchar(64) 非空，`table_name` varchar(64) 非空，PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`))COMMENT='导航树的隐藏项'默认字符集 utf8 整理 utf8_bin;

错误

SQL 查询:

<块引用>

如果不存在则创建表 pma_users ( username varchar(64) NOTNULL, usergroup varchar(64) NOT NULL, PRIMARY KEY(username,usergroup) ) COMMENT='用户及其分配给用户组的 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin

MySQL 说:文档

1046 - 未选择数据库

解决方案

解决windows下xampp中的配置存储问题:

转到 localhost/phpmyadmin 和

中的导入选项卡

浏览xamppphpMyAdminsql 文件夹并选择create_tables.sql 和

然后点击开始按钮

现在 phpmyadmin 数据库已添加到您的数据库列表

现在我们必须为此数据库创建用户帐户:

用户标签并点击添加用户

<块引用>

名称:pma

<块引用>

密码:pmappass

然后点击去

为这个用户的权限创建一个文件:pma_privileges.sql

有这个内容:

GRANT USAGE在 mysql.* TO 'pma'@'localhost';授予选择(主机、用户、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、Executes_priv、Reload_priv、ON mysql.user TO 'pma'@'localhost';授予选择ON mysql.db TO 'pma'@'localhost';授予选择(主机、数据库、用户、Table_name、Table_priv、Column_priv)ON mysql.tables_priv TO 'pma'@'localhost';授予选择,插入，更新,删除ON phpmyadmin.* TO 'pma'@'localhost';

并通过导入选项卡导入

现在我们创建具有权限的数据库和用户

我们必须将它们添加到 xamppphpMyAdmin 文件夹中的 config.inc.php 文件

所以添加这些:

 $cfg['Servers'][$i]['controluser'] = 'pma';$cfg['Servers'][$i]['controlpass'] = 'pmappass';/* 存储数据库和表 */$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]['table_uiprefs'] = 'pma__table_uiprefs';$cfg['Servers'][$i]['tracking'] = 'pma__tracking';$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';$cfg['Servers'][$i]['recent'] = 'pma__recent';$cfg['Servers'][$i]['f​​avorite'] = 'pma__favorite';$cfg['Servers'][$i]['users'] = 'pma__users';$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';

现在重启mysql和浏览器，配置存储错误消失

创建表中注释后的列可见

I have installed xampp 5.6.14 on windows. I open phpmyadmin http://localhost/phpmyadmin/

but warning

! The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to 'Operations' tab of any database to set it up there.

! You are connected as 'root' with no password, which corresponds to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.

How to solve it?

UPDATE: I see my issue in PMA Database ... not OK in phpMyAdmin upgrade but i don't understand. When I create database with contents in "create_tables.sql" by sql query in phpmyadmin but it's error

CREATE TABLE IF NOT EXISTS `pma_users` (
  `username` varchar(64) NOT NULL,
  `usergroup` varchar(64) NOT NULL,
  PRIMARY KEY (`username`,`usergroup`)
) 
  COMMENT='Users and their assignments to user groups'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE IF NOT EXISTS `pma_usergroups` (
  `usergroup` varchar(64) NOT NULL,
  `tab` varchar(64) NOT NULL,
  `allowed` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`usergroup`,`tab`,`allowed`)
) 
  COMMENT='User groups with configured menu items'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE IF NOT EXISTS `pma_navigationhiding` (
  `username` varchar(64) NOT NULL,
  `item_name` varchar(64) NOT NULL,
  `item_type` varchar(64) NOT NULL,
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)
) 
  COMMENT='Hidden items of navigation tree'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

Error

SQL query:

CREATE TABLE IF NOT EXISTS pma_users ( username varchar(64) NOT NULL, usergroup varchar(64) NOT NULL, PRIMARY KEY (username,usergroup) ) COMMENT='Users and their assignments to user groups' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin

MySQL said: Documentation

1046 - No database selected

解决方案

resolving configuration storage problem in xampp in windows :

go to import tab in localhost/phpmyadmin and

browse xamppphpMyAdminsql folder and select create_tables.sql and

then click go button

now phpmyadmin db added to your db list

now we must create user account for this db :

users tab and click add user

name : pma

password : pmapass

and click go

for privilege of this user create a file : pma_privileges.sql

with this content :

GRANT USAGE 
ON mysql.* TO 'pma'@'localhost';
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
(Host, Db, User, Table_name, Table_priv, Column_priv) 
   ON mysql.tables_priv TO 'pma'@'localhost';
GRANT 
SELECT
,
   INSERT,
   UPDATE
,
      DELETE
         ON phpmyadmin.* TO 'pma'@'localhost';

and import it by import tab

now we create db and user with privilege so now

we must add them to config.inc.php file in xamppphpMyAdmin folder

so add these :

    $cfg['Servers'][$i]['controluser'] = 'pma';
    $cfg['Servers'][$i]['controlpass'] = 'pmapass';
    
    /* 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]['table_uiprefs'] = 'pma__table_uiprefs';
    $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
    $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
    $cfg['Servers'][$i]['recent'] = 'pma__recent';
    $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
    $cfg['Servers'][$i]['users'] = 'pma__users';
    $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
    $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
    $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
    $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';

now restart the mysql and browser and the configuration storage error disappear and

columns after comment in creating table are visible

这篇关于phpMyAdmin 配置存储未完全配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！