[xampp] phpmyadmin 设置登录密码

$ cd /opt/lampp/bin

$ ./mysqladmin -u root password 'new_password'

$ vim ../phpmyadmin/config.inc.php

修改这部分:

$cfg['Servers'][$i]['auth_type'] = 'config'; # 改为 $cfg['Servers'][$i]['auth_type'] ='cookie'

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = ''; # 改为 $cfg['Servers'][$i]['password'] = 'new_password'

特别提醒:

$cfg['Servers'][$i]['auth_type'] = 'config'; 如果每改为cookie,那么登录Phpmyadmin还是不需要密码的

　　

方法二:在phpmyadmin中修改

进入mysql数据库,执行

update user set password=password('123456') where User='root'

然后修改 /opt/lampp/phpmyadmin/config.inc.php. 同方法一

记得重启mysql才能生效

/opt/lampp/lampp restart