$ 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