Menu
▾
▴
#2672 (ok 2.11.6) Access denied for user 'root'@'localhost'
With phpMyAdmin 2.11.5.1 I kept gettimng "#1045 - Access denied for user 'root'@'localhost' (using password...". I double-checked my password, etc..
I ended up checking out 3.0.0-dev from SVN and when I pulled it up, it reported on the login interface that "mcrypt" was missing in my list of extensions. I installed it, restarted the webserver and it worked instantly.
(Sidenote: PHP5 on Ubuntu doesn't have mcrypt by default. I actually needed to add "universe" to my packages and get it from there.)
The note about mcrypt should probably be "backported" to the 2.x branch. I know this probably happens only once in a lifetime (;-)) or whenever you setup a new server, but it would be a huge convenience.
Category: Usability
Group: 2.11.5.1
Discussion
Logged In: YES
user_id=1383652
Originator: NO
"Cannot load mcrypt extension. Please check your PHP configuration."
is reported on the main page of pma 2.11 already - but only *after* a successful login.
Could be more helpful on the login page in such cases ...
Logged In: YES
user_id=210714
Originator: NO
Hmmm... not being able to load mcrypt in 2.11.5.1 should not produce an access denied, there is a blowfish.php library (slower) that is loaded in this case. Are you sure?
Logged In: YES
user_id=1383652
Originator: NO
Marc,
the blowfish routines fail silently on some 64bit boxes (maybe fixed in recent php versions)
Logged In: YES
user_id=296596
Originator: YES
Should have maybe added the following:
PHP 5.2.1 (cli) (built: Feb 20 2007 20:11:58)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
Linux server 2.6.22.19-grsec2.1.11-vs2.2.0.6 #3 SMP Sun Mar 16 12:22:23 CET 2008 x86_64 GNU/Linux
Logged In: YES
user_id=1383652
Originator: NO
see http://wiki.cihar.com/pma/Requirements (I added this in Feb. 2007):
<quote>
On 64 bit systems the mcrypt PHP extension is required for auth_type "cookie". The alternative blowfish routines only work on 32-bit systems at the moment (due to a PHP 5.2.0/1 bug, should be fixed in PHP 5.2.2 meanwhile). The same issue leads to the cryptic "#1045 access denied for user www-data.." messages on Ubuntu boxes.
</quote>
Logged In: YES
user_id=210714
Originator: NO
Thanks Juergen, I remember now :)
Warning message backported to 2.11.6-dev. Maybe it's easier to upgrade phpMyAdmin than to upgrade PHP.
Logged In: YES
user_id=296596
Originator: YES
It is for sure, unfortunately I am stuck with 5.2.1 on this system. Not sure how soon the repositories will be bumped up. It was easier for me to install "php5-mcrypt" once I knew.
Thanks for working on this. :)
(Btw, 3.0.0-dev is looking pretty solid. :))
Logged In: YES
user_id=2059302
Originator: NO
The problem is with the phpmyadmin code itself. the file common.inc.php is wrong. this file is located in the libraries folder. the orginal code:
if ($_SESSION['PMA_Config']->error_config_file) {
$GLOBALS['PMA_errors'][] = $strConfigFileError
. '<br /><br />'
. ($_SESSION['PMA_Config']->getSource() == './config.inc.php' ?
'<a href="show_config_errors.php"'
.' target="_blank">' . $_SESSION['PMA_Config']->getSource() . '</a>'
:
'<a href="' . $_SESSION['PMA_Config']->getSource() . '"'
.' target="_blank">' . $_SESSION['PMA_Config']->getSource() . '</a>');
}
and it needs to be modified to say
if ($_SESSION['PMA_Config']->error_config_file) {
$GLOBALS['PMA_errors'][] = $strConfigFileError
. '<br /><br />'
. ($_SESSION['PMA_Config']->getSource() == './config/config.inc.php' ?
'<a href="show_config_errors.php"'
.' target="_blank">' . $_SESSION['PMA_Config']->getSource() . '</a>'
:
'<a href="' . $_SESSION['PMA_Config']->getSource() . '"'
.' target="_blank">' . $_SESSION['PMA_Config']->getSource() . '</a>');
}
all i really changed was one line: "getSource() == './config/config.inc.php' " the orginal code points to ./config.inc.php and not ./config/config.inc.php
THIS IS FOR PHPMYADMIN 2.11.5.1
Logged In: YES
user_id=210714
Originator: NO
wesgann,
I don't agree. In Documentation.html we clearly indicate that config/config.inc.php is only intended for the setup script, not for running phpMyAdmin. This why there is no config directory in the downloaded kit.