第一种情况:
1.直接先用phpmyadmin改MYSQL密码;
2.然后找到phpmyadmin/config.inc.php,
$cfg['Servers'][$i]['password'] = 'newpass';//新密码;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;//不允许密码为空;
第二种情况:
1.先用MYSQL控制台用命令修改密码;
我找到两种命令能直接在MYSQL命令行,修改密码;
(1) mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');//比较简单的
mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpass');
(2)use mysql;
UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
FLUSH PRIVILEGES;//即刻刷新MYSQL不用重启就可使用;
2.同第一种情况;