Posted by:
RajRB
(---.static.ziggozakelijk.nl)
Hi RiggsFolly,
Thanks a lot for a quick response!. I have never seen such a response for my query anywhere
So happy!
Atlast, it worked just now using MySql console with the following commands as per this link
(http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html)
shell> mysql -u root
mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd')
-> WHERE User = 'root';
mysql> FLUSH PRIVILEGES;
Then I restarted my wamp and it logged into phpadmin only with the password.
But why does still my config.inc.php looks like below;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
//$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
/* 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;
Thanks a lot RiggsFolly! I really appreciate your concern.