phpMyAdmin配置存储未完全配置 [英] phpMyAdmin configuration storage is not completely configured
问题描述
我已经在Windows上安装了xampp 5.6.14.我打开phpmyadmin http://localhost/phpmyadmin/
I have installed xampp 5.6.14 on windows. I open phpmyadmin http://localhost/phpmyadmin/
但警告
! phpMyAdmin配置存储未完全配置, 一些扩展功能已被停用.找出为什么. 或者,也可以转到任何数据库的操作"标签,在此处进行设置.
! 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.
!您以"root"身份连接,没有密码,这对应于 默认的MySQL特权帐户.您的MySQL服务器正在运行 此默认设置容易受到入侵,您确实应该解决此问题 通过为用户"root"设置密码来保护安全漏洞.
! 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'.
如何解决?
更新: 我在 PMA数据库中发现了问题...在phpMyAdmin升级中不正确但我不明白.当我通过phpmyadmin中的sql查询在"create_tables.sql"中创建内容包含数据库的数据库时,这是错误的
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;
错误
SQL查询:
如果不存在则创建表
pma_users
(username
varchar(64)NOT NULL,usergroup
varchar(64)不是NULL,主键 (username
,usergroup
))COMMENT ='用户及其分配给 用户组的默认字符集utf8收集utf8_bin
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表示:文档
MySQL said: Documentation
推荐答案
解决Windows xampp中的配置存储问题:
resolving configuration storage problem in xampp in windows :
转到localhost/phpmyadmin中的导入选项卡,然后
go to import tab in localhost/phpmyadmin and
浏览xampp \ phpMyAdmin \ sql文件夹,然后选择create_tables.sql和
browse xampp\phpMyAdmin\sql folder and select create_tables.sql and
然后单击转到"按钮
现在phpmyadmin数据库已添加到您的数据库列表中
now phpmyadmin db added to your db list
现在我们必须为此数据库创建用户帐户:
now we must create user account for this db :
用户标签,然后点击添加用户
users tab and click add user
名称:pma
密码:pmapass
password : pmapass
然后点击执行
为此用户的特权,创建一个文件:pma_privileges.sql
for privilege of this user create a file : pma_privileges.sql
具有以下内容:
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';
并通过导入标签导入
现在我们创建具有特权的数据库和用户,
now we create db and user with privilege so now
我们必须将它们添加到xampp \ phpMyAdmin文件夹中的config.inc.php文件中
we must add them to config.inc.php file in xampp\phpMyAdmin folder
所以添加这些:
$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';
现在重新启动mysql和浏览器,配置存储错误消失并且
now restart the mysql and browser and the configuration storage error disappear and
在创建表中的注释后的列可见
columns after comment in creating table are visible
这篇关于phpMyAdmin配置存储未完全配置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!