I updated the root password for my mysql installation, and then I updated my config.inc.php file in my phpmyadmin directory with the new password. (Before this root had no password)
If I now go to localhost/phpmyadmin , I cannot access the top level (where I can create databases, edit priveleges etc), but I can access any of the databases I have already created. When I try go to the top level I get:
1045 - Access denied for user 'root'@'localhost' (using password: NO)
Quite sure this is a simple problem! Thanks
In config.inc.php, change:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'cbb74bc';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
That way it will prompt you to log-in with credentials. Use the root user/pass to access the root account, and whatever DB user account you have to use just that user.
This topic is now archived. It is frozen and cannot be changed in any way.