Monday, April 6, 2015

Add login screen and second user login in PHPMyAdmin

1) Default  PHPMyAdmin without login screen. To add  login screen:
Go to Users, find root@localhost and edit privileges and change password. Use same password in XAMPP configuration

2) Under xampp/phpMyAdmin/
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'test';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

3) To add second name and password in login scrren:
Go to Users tab in PHPMyAdmin, Add new User, type username and password, select host as localhost and check all and click go.

Video: Add login screen and second user login  in PHPMyAdmin

No comments:

Post a Comment