But there is one problem if you want to install it localhost which is annoying login after AFK for a while
I have google for these solution and the result wasnt good enough so I post this so I can refer it back
Manage to work it out by referring the manual http://www.phpmyadmin.net/documentation/#servers_user
Nows lets disable the annoying login
Advantage: no annoying
Disadvantage: Less secure, password stored in a file without encrypted
These was tested on Ubuntu machine version 10.10 so I'm not sure about windows
The version of phpmyadmin is 3.3.7deb3build0.10.10.1
1st open the configuration of the phpmyadmin file
sudo gedit /etc/phpmyadmin/config.inc.php
Search for string "/* Authentication type */" (its at line no 35)
Disable the "cookie" auth_type and put these code. It should look like these
/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mypasswordissecret';
So you eventually change the auth_type into 'config' and you required to put the username and password for that
To test the annoying login is now disabled, restart your FireFox (reset the cache) and try to direct to the phpmyadmin (In my case I type "http://localhost/phpmyadmin/" in my FireFox URL)
It work when you are not asked for login. KUPO!
p/s: I know the file was /etc/phpmyadmin/config.ini.php is from file /var/www/phpmyadmin/config.inc.php
Edit 29 Nov 2012
For phpMyAdmin 3.4.11 the configuration file for windows was in libraries/config.default.php
here is my setting, for localhost development
$cfg['Servers'][$i]['auth_type'] = 'config'; //Default is cookie
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['nopassword'] = true; //Default is false
$cfg['Servers'][$i]['AllowNoPassword'] = true; //Default is false
No comments:
Post a Comment