This is quite common problem and I found a lot of tutorials to help me solve it, although, there is one additional problem with my case...
This is my config settings in config.inc.php
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;
When I try to log in via wamp main page, the error shows:
1045 - Access denied for user 'root'@'localhost' (using password: YES)
AND this same is when I try to acces MyAdmin by CONSOLE!
No matter what I type as password or just press enter, it shows me this same error, and because of that i cant 'flush priviliges'.
What can I do?
go to
control panel > administrative tool> service >
then you will find a list of items , navigate to
MYSQL
right click on its
properties
, ingeneral tab
start typemake it automatic
then
apply / save
and finally
restart all services in wamp