xampp默认mysql密码设置，修改mysql的默认空密码

1.进入phpmyadmin的mysql数据库，执行如下语句
[code]UPDATE
user SET password=PASSWORD(‘new_password’)
WHERE user=’root’;[/code]
2.phpmyadmin中的对应密码配置也要修改，找到配置文件，如我的是：
F:\xampp\phpMyAdmin\config.inc.PHP
找到如下代码
[code]
/*
Authentication type and info */

$cfg[‘Servers’][$i][‘auth_type’]
= ‘config’;

$cfg[‘Servers’][$i][‘user’]
= ‘root’;

$cfg[‘Servers’][$i][‘password’]
= ”;

$cfg[‘Servers’][$i][‘extension’]
= ‘mysql’;

$cfg[‘Servers’][$i][‘AllowNoPassword’]
= true;
[/code]
修改为

[code]

/*
Authentication type and info */

$cfg[‘Servers’][$i][‘auth_type’]
= ‘config’;

$cfg[‘Servers’][$i][‘user’]
= ‘root’;

$cfg[‘Servers’][$i][‘password’]
= ‘123456’;

$cfg[‘Servers’][$i][‘extension’]
= ‘mysql’;

$cfg[‘Servers’][$i][‘AllowNoPassword’]
= true;
[/code]