Change MySQL root password in phpMyAdmin
mysql, php, phpmyadmin
Solution
Explain what video describe to resolve problem
After Changing Password of root (Mysql Account). Accessing to phpmyadmin page will be denied because phpMyAdmin use root/''(blank) as default username/password. To resolve this problem, you need to reconfig phpmyadmin. Edit file config.inc.php in folder %wamp%\apps\phpmyadmin4.1.14 (Not in %wamp%)
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'changed';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
If you have more than 1 DB server, add "i++" to file and continue add new config as above
Problem
I've setup `wamp` server on window. Then, I use MySQL `root` password by cmd. As a result, when I access phpMyAdmin site, `Access denied` appeared (Default user for phpMyAdmin is `root` and password is `blank/empty`). So, how could I change `config` variables in phpMyAdmin with new password of root. I've searched for solution on Internet, someone advise me add some line to `config.inc.php` as: ``` $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'Changed'; $cfg['Servers'][$i]['AllowNoPasswordRoot'] = false; ``` But, It seem not work. Thanks.