error in phpmyadmin
Posted by: darksteel (---.prtc.net)
Date: April 12, 2006 03:46PM

MySQL ha dicho: Documentación
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I configured the file,

$cfg['Servers'][$i]['controluser'] = 'root'; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = 'root'; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'root'; // MySQL password (only needed


I use root user and root passwd to my phpmyadmin, but show error...

thankyou

darksteel-


Re: error in phpmyadmin
Posted by: CyberSpatium (---.hsd1.or.comcast.net)
Date: April 12, 2006 08:40PM

change these two lines:
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'root';

To:
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';

Change this setting to what your the password is for your root user. if you have not changed the root users password, then leave it blank:
$cfg['Servers'][$i]['password'] = 'root';

Sorry, only registered users may post in this forum.