php “退出”phpMyAdmin?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/16873448/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
"Logging out" of phpMyAdmin?
提问by OpMt
The error that I get on phpMyAdmin is the following
我在 phpMyAdmin 上得到的错误如下
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated."
I have googled and looked this up for a while now and the common answer that comes up is to Log Out/In or the clear the cookies and cache. Clearing the cookies and caches did not work for me. I have tried to logout, but cannot seem to be able to find out how to, because in the updated version of phpMyAdmin, I believe that there is no logout button as opposed to the older versions which is why people posted that as a solution before. I am not sure what version of phpMyAdmin I have because I downloaded it through xampp, but this is what mine looks like:
我已经用谷歌搜索并查找了一段时间,出现的常见答案是注销/登录或清除 cookie 和缓存。清除 cookie 和缓存对我不起作用。我试图注销,但似乎无法找到如何注销,因为在 phpMyAdmin 的更新版本中,我相信没有注销按钮而不是旧版本,这就是为什么人们之前将其发布为解决方案的原因. 我不确定我有什么版本的 phpMyAdmin,因为我是通过 xampp 下载的,但这是我的样子:
回答by Dileep
click on this button out your phpAdmin home page
在您的 phpAdmin 主页上单击此按钮
回答by Felipe Vasconcelos
As said hereand i quote:
正如这里所说,我引用:
just change this line on config.inc.php
$cfg['Servers'][$i]['auth_type'] = 'config';
to
$cfg['Servers'][$i]['auth_type'] = 'cookie';
then you will be prompted to login when you refreshed the page. Afterwards, the log out icon will appear next to home icon.
只需更改config.inc.php 上的这一行
$cfg['Servers'][$i]['auth_type'] = 'config';
到
$cfg['Servers'][$i]['auth_type'] = 'cookie';
那么当您刷新页面时,系统会提示您登录。之后,注销图标将出现在主页图标旁边。
回答by L. D. James
The second button from the left. The one on the right of the house in the image you posted is your logout button.
左起第二个按钮。您发布的图片中房屋右侧的那个是您的注销按钮。
For your error message try this link in the documentation: http://wiki.phpmyadmin.net/pma/Configuration_storage
对于您的错误消息,请尝试文档中的此链接:http: //wiki.phpmyadmin.net/pma/Configuration_storage
Make certain you have a phpadmin control user account created. This is covered in the second paragraph in on the documentation page in the link.
确保您创建了一个 phpadmin 控制用户帐户。这在链接的文档页面的第二段中有所介绍。
回答by Nolwennig
In one click
一键
Logout from PhpMyAdmin with URL like /phpmyadmin/index.php?old_usr=xy
从 PhpMyAdmin 使用 URL 退出,例如 /phpmyadmin/index.php?old_usr=xy
EDIT:It works with PhpMyAdmin version 4.0.10.18
?
编辑:它适用于 PhpMyAdmin 版本4.0.10.18
?
回答by Vykthur D .
This happens because the current account you have used to log in probably has very limited priviledges.
发生这种情况是因为您用于登录的当前帐户可能具有非常有限的权限。
To fix this problem, you can change your the AllowNoPassword config setting to false in config.inc.php
. You may also force the authentication to use the config file and specify the default username and password .
要解决此问题,您可以将 AllowNoPassword 配置设置更改为config.inc.php
. 您还可以强制身份验证使用配置文件并指定默认用户名和密码。
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; // leave blank if no password
After this, the PhPMyAdmin login page should show up when you refresh the page. You can then log in with the default root password.
在此之后,刷新页面时应显示 PhPMyAdmin 登录页面。然后,您可以使用默认的 root 密码登录。
More details can be found on this post ..
回答by rixo
The presence of the logout button depends on whether you are required to login or not, in the first place. This is tweakable in PHPMyAdmin config files.
注销按钮的存在首先取决于您是否需要登录。这可以在 PHPMyAdmin 配置文件中进行调整。
Yet, I don't think that would change anything concerning your error message. You would need to fix the configuration for the message to go away.
但是,我认为这不会改变有关您的错误消息的任何内容。您需要修复配置以使消息消失。
Edit: this isthe kind of solution you should be searching for. And here are plenty of othersfor you to explore ^^
回答by Milind Morey
Simple seven step to solve issue in case of WampServer:
解决WampServer问题的简单七步:
- Start WampServer
- Click on Folder icon Mysql -> Mysql Console
- Press Key Enter without password
Execute Statement
SET PASSWORD FOR root@localhost=PASSWORD('root');
open D:\wamp\apps\phpmyadmin4.1.14\config.inc.php file set value
$cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = '';
Restart All services
- Open phpMyAdmin in browser enter user root and pass root
- 启动 WampServer
- 单击文件夹图标 Mysql -> Mysql Console
- 不用密码按回车键
执行语句
SET PASSWORD FOR root@localhost=PASSWORD('root');
打开 D:\wamp\apps\phpmyadmin4.1.14\config.inc.php 文件设置值
$cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = '';
重启所有服务
- 在浏览器中打开 phpMyAdmin 输入用户 root 并通过 root