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:
Answers
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.
click on this button out your phpAdmin home page
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.
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
0 comments:
Post a Comment