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/config.inc.php
change
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
to
$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