修改xampp中的MySQL密码
1.开启MySQL服务后,点击XAMPP Control Panel上的Admin按钮
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017153659434-226975074.png)
2.依次点击“账户”——最后一个“修改权限”——修改密码
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017154008029-724853110.png)
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017154016402-1779160762.png)
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017154108108-1266692498.png)
3.输入两次相同密码,完了别忘记点右下角的“执行”
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017154212431-1351391128.png)
4.重新访问phpMyAdmin会报错
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017154409021-1420007257.png)
5.打开xampp安装目录下,phpMyAdmin目录内的config.inc.php文件(xamppphpMyAdminconfig.inc.php)
6.大概在第21行,找到$cfg['Servers'][$i]['password'] = '';
,填入刚刚修改的密码并保存。
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017154811895-334914273.png)
7.重新访问phpMyAdmin,现已能正常访问。
![](https://img2018.cnblogs.com/blog/1113227/201910/1113227-20191017154935048-1953818702.png)
原文地址:https://www.cnblogs.com/Subaru/p/11692410.html