修改wampserver2.5中的mysql密码

安装wampserver2.5

下载: wampserver2.5   访问密码 c6c7
双击安装:  一路next

修改mysql密码

1. 启动wampserver

2. 打开mysql控制台
   

1. 默认密码为空,所以回车就可以进入数据库,执行以下命令修改root用户的密码

use mysql;

update user set password=PASSWORD('你的密码') where user='root';

flush privileges;

quit

修改phpmyadmin的登录密码

1. 打开目录,C:\wamp\apps\phpmyadmin4.1.14并找到conf.inc.php,修改password的值:

$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'TingShuo2';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

重启完成