windows phpMyAdmin 配置存储未完全配置

phpMyAdmin configuration storage is not completely configured

提问by AzVoz

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

我已经在 Windows 上安装了 xampp 5.6.14。我打开 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'.

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

！您以没有密码的“root”身份连接，这对应于默认的 MySQL 特权帐户。您的 MySQL 服务器正在使用此默认值运行，对入侵开放，您确实应该通过为用户“root”设置密码来修复此安全漏洞。

How to solve it?

如何解决？

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

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

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:

SQL查询：

CREATE TABLE IF NOT EXISTS pma_users( usernamevarchar(64) NOT NULL, usergroupvarchar(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

CREATE TABLE IF NOT EXISTS pma_users( usernamevarchar(64) NOT NULL, usergroupvarchar(64) NOT NULL, PRIMARY KEY ( username, usergroup) ) COMMENT='用户及其分配给用户组的默认字符集 utf8 COLLATE utf8_bin

MySQL 说： 文档

1046 - 没有选择数据库

回答by xmoooz

resolving configuration storage problem in xampp in windows :

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

go to import tab in localhost/phpmyadmin and

转到 localhost/phpmyadmin 中的导入选项卡和

browse xampp\phpMyAdmin\sql folder and select create_tables.sql and

浏览 xampp\phpMyAdmin\sql 文件夹并选择 create_tables.sql 和

then click go button

然后点击去按钮

now phpmyadmin db added to your db list

现在 phpmyadmin db 添加到您的 db 列表中

now we must create user account for this db :

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

users tab and click add user

用户选项卡，然后单击添加用户

name : pma

名称 : pm

password : pmapass

密码：pmap

and click go

然后点击去

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

为这个用户的权限创建一个文件：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 xampp\phpMyAdmin folder

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

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

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

columns after comment in creating table are visible

创建表中注释后的列可见

回答by Isaac Bennetch

The officially distributed create_tables.sqlscript includes a line to create and use the 'phpmyadmin' database, so perhaps XAMPP changes things.

官方分发的create_tables.sql脚本包含一行来创建和使用 'phpmyadmin' 数据库，所以 XAMPP 可能会改变一些事情。

Note that I don't use XAMPP and I expected that their installer would have set this all up for you, so there may be something wrong there that should be fixed in a more proper way, but one possible solution might be to download the official phpMyAdmin versionof create_tables.sqland use that, or you could just add the following line at the top of your sql file:

请注意，我不使用 XAMPP，我希望他们的安装程序会为您设置好这一切，因此可能有问题应该以更正确的方式修复，但一种可能的解决方案可能是下载官方phpMyAdmin的版本中create_tables.sql，并使用该，或者你可以只添加下面一行在你的SQL文件的顶部：

CREATE DATABASE IF NOT EXISTS `phpmyadmin`
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;

回答by Snehal More

First in phpMyAdmin go to users -> search the user "root"and host "localhost".then select option -> edit privileges after that go to -> change password set your password for root there.

首先在 phpMyAdmin 中转到用户 -> 搜索用户“root”并托管“localhost”。然后选择选项->编辑权限，然后转到->更改密码在那里设置root密码。

then go to xampp folder -> phpmyadmin -> config.inc.php change config to cookie. and password to your new password. $cfg['Servers'][$i]['auth_type'] = 'config'; ----> cookie $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; -----> new password(what you set for user root)

然后转到 xampp 文件夹 -> phpmyadmin -> config.inc.php 将配置更改为 cookie。和密码到您的新密码。 $cfg['Servers'][$i]['auth_type'] = 'config'; ----> cookie $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; -----> new password(what you set for user root)

回答by Maulik Prajapati

This is what I did to enable the advanced features (using the latest version 3.4.x)

First login to phpmyadmin and create a new database called phpmadmin. When you have created the database select the import tab at the top of the page. Click the Browse/Choose file button and navigate to your phpmyadmin folder and open the scripts directory and select the create_tables.sql file. Click open to close the window. Then press Go (bottom of page). The database for the control user has been setup.

Next to setup the control user. Go to the phpmyadmin home screen and click the privileges tab. Click the add a new user link. For the username type phpmyadmin. Set anything as the password (Make sure you remember it). Choose the option to Create database with same name and grant all privileges And then click the Go button.

You have now setup the control user and the database for phpmyadmin. You now need to configure phpmyadmin. Open the config file (called config.inc.php). And remove the // from the start of the following lines

/* User used to manipulate with storage */
// $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]['tracking'] = 'pma_tracking';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
// $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';


Make sure you set $cfg['Servers'][$i]['controluser'] to phpmyadmin and apply the password to $cfg['Servers'][$i]['controlpass']. Log out of phpmyadmin, then log back in (not as the control user). The advanced features should now be enabled.