"Logging out" of phpMyAdmin?

Question

The error that I get on phpMyAdmin is the following

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

You did not specified the version you are using so no comparison can be made. — Gimmy, Jun 01 '13 at 14:02
@Gimmy How can I check what version I downloaded, because I believe I downloaded it through xampp? (Also updated question with image) — OpMt, Jun 01 '13 at 14:15
The version of phpMyAdmin is located on the bottom right corner of the page in the "phpMyAdmin" section. — aphoe, Aug 04 '14 at 23:46

score 54 · Answer 1 · edited Apr 21 '17 at 19:16

54

enter image description here

click on this button out your phpAdmin home page

edited Apr 21 '17 at 19:16

Paul Roub

36,322
27
84
93

answered Apr 21 '17 at 15:11

Dileep

583
4
3

3

I have no such button. – Ralf Apr 07 '20 at 12:10
1

This button does not always exist. Can you send the link of the button when you hover over it? – BonisTech Mar 09 '21 at 08:53
1

@JonasMerhej the link looks like http://localhost/phpmyadmin/logout.php?db=&token=07c14c216cb42b675637b66ff28013ec – Alfie May 25 '21 at 16:25

score 42 · Answer 2 · edited May 23 '17 at 11:33

42

As said here and 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.

edited May 23 '17 at 11:33

Community

1
1

answered Jul 13 '14 at 05:31

Felipe Vasconcelos

2,067
1
22
29

score 12 · Answer 3 · answered Dec 31 '13 at 00:56

12

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

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.

answered Dec 31 '13 at 00:56

L. D. James

1,679
1
22
35

2

That button opens a query window (PHPMyAdmin v4.1.6) – PeerBr Mar 07 '14 at 15:56
2

That button opens a query window (PHPMyAdmin v3.5.8.2) – Pang Mar 09 '14 at 04:09
You're right. The OP's icon picture shows 5 icons. I have 6 icons on l my phpmyadmin installs. There is a logout icon between the home icon and the query icon. Both the logout and query icon has a green arrow as part of the icon. I mistook position of his query icon as the logout icon. Since you (and the OP) appear to be missing the logout icon (one of the default six that has been in all my installs since v3.3), you appear to have a faulty installation. Try a fresh install. In the meantime I'll try a few and see if I can experience the problem you're getting. – L. D. James Mar 09 '14 at 14:09

Nolwennig · Answer 4 · 2018-04-23T08:49:22.997

9

In one click

Logout from PhpMyAdmin with URL like /phpmyadmin/index.php?old_usr=xy

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

EDIT: It works with PhpMyAdmin version 4.0.10.18?

edited Apr 23 '18 at 08:49

answered Sep 22 '15 at 11:42

Nolwennig

1,613
24
29

score 2 · Answer 5 · answered Jun 01 '13 at 14:27

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.

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 is the kind of solution you should be searching for. And here are plenty of others for you to explore ^^

score 1 · Answer 6 · edited Dec 16 '17 at 11:46

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 .

$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.

More details can be found on this post ..

score -1 · Answer 7 · edited Jun 12 '18 at 09:44

-1

Simple seven step to solve issue in case of 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

edited Jun 12 '18 at 09:44

Munim Munna

17,178
6
29
58

answered May 12 '16 at 02:57

Milind Morey

2,100
19
15

The question is about `xampp`, not `wamp`. – Munim Munna Jun 12 '18 at 09:37

"Logging out" of phpMyAdmin?

7 Answers7

In one click

Linked