Unable to access MySQL from MyPHPAdmin after setting root password in EasyPHP{WAMP}

Question

Am a new starter with WAMP and trying to play around my way using the EasyPHP setup. After successful setup on intial launch of MySQL, the page prompted me to set up ROOT password for security reasons.

On setting the password, am no longer able to access MySQL. The error is :

Error

MySQL said: Documentation
1045 - Access denied for user 'root'@'localhost' (using password: NO) 

Looked up on the net and tried the following options in the config.inc.php from the phpmyadmin foler:

1] Set the authetication to "http" so that it prompts to enter the username and password

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';

2] Set up the correct password in the config file

$cfg['Servers'][$i]['password'] = 'myPwd';

None of them worked.

Can anyone suggest a workaround to access MySQL? Am not fussed about not being able to use the root account but would like to CRUD on the database using other username.

Thanks in advance.

Answer 1

Hi Codex, here is my phpmyadmin config.inc.php file:

<?php

$i = 0;
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

?>

That should be enough if Apache/PHP is running on the same machine as MySQL. Then you will be prompted for a username and password. Enter root and the password that you set.