sheardben — 2012-08-09T07:49:54-04:00 — #1
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
kduv — 2012-08-14T20:47:43-04:00 — #2
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.
mittineague — 2014-09-20T03:06:15-04:00 — #3
This topic is now archived. It is frozen and cannot be changed in any way.