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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-25 11:49:42  来源:igfitidea点击:

"Logging out" of phpMyAdmin?

phpphpmyadminconfigure

提问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: enter image description here

我已经用谷歌搜索并查找了一段时间,出现的常见答案是注销/登录或清除 cookie 和缓存。清除 cookie 和缓存对我不起作用。我试图注销,但似乎无法找到如何注销,因为在 phpMyAdmin 的更新版本中,我相信没有注销按钮而不是旧版本,这就是为什么人们之前将其发布为解决方案的原因. 我不确定我有什么版本的 phpMyAdmin,因为我是通过 xampp 下载的,但这是我的样子:在此处输入图片说明

回答by Dileep

enter image description here

在此处输入图片说明

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

source : https://stackoverflow.com/a/23143634/4457531

来源:https: //stackoverflow.com/a/23143634/4457531



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问题的简单七步:

  1. Start WampServer
  2. Click on Folder icon Mysql -> Mysql Console
  3. Press Key Enter without password
  4. Execute Statement

    SET PASSWORD FOR root@localhost=PASSWORD('root');
    
  5. open D:\wamp\apps\phpmyadmin4.1.14\config.inc.php file set value

    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['user'] = '';
    
  6. Restart All services

  7. Open phpMyAdmin in browser enter user root and pass root
  1. 启动 WampServer
  2. 单击文件夹图标 Mysql -> Mysql Console
  3. 不用密码按回车键
  4. 执行语句

    SET PASSWORD FOR root@localhost=PASSWORD('root');
    
  5. 打开 D:\wamp\apps\phpmyadmin4.1.14\config.inc.php 文件设置值

    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['user'] = '';
    
  6. 重启所有服务

  7. 在浏览器中打开 phpMyAdmin 输入用户 root 并通过 root