root user password problem
Posted by: oholymike (---.neo.res.rr.com)
Date: July 10, 2010 12:05AM

I'm running Wamp 2 under Vista with PHP 5.3.0 and MySQL 5.1.36. Like an idiot, I reset the passwords for the root users on localhost and my hosting company, and now phpMyAdmin won't run--the error message is

"MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO). phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."

From what I've read, I'm supposed to be fixing it in config.inc.php, but I can't find that file anywhere in my installation. Then I searched for it with Windows Search, and it's no where on my entire computer.

Any help would be hugely appreciated.

Re: root user password problem
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: July 10, 2010 12:16AM

config.inc.php is located in C:/wamp/apps/phpMyadmin<version>

Re: root user password problem
Posted by: oholymike (---.neo.res.rr.com)
Date: July 10, 2010 12:55AM

Ok, thanks dan. . .now here's what I have in config.inc.php:

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$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'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

What should I do to correct this?

I also see config.sample.inc.php in there. Should it be, or should I have renamed that config.inc.php before this point?

Re: root user password problem
Posted by: yfastud (Moderator)
Date: July 10, 2010 03:25AM


Re: root user password problem
Posted by: oholymike (---.neo.res.rr.com)
Date: July 10, 2010 05:02AM

Hey thanks alot. . .that worked perfectly!

Sorry, only registered users may post in this forum.