Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin
I have installed PHPMyAdmin on my windows machine running IIS 7.0.
I was able to connect to MySQL using command-line, But I can;t able to connect using PHPMyAdmin.
The error displayed was: Error #1045 Cannot log in to the MySQL server.
Can anyone please help me with this ?
PHP Version 5.4.0
mysqlnd 5.0.10 - 20111026 - $Revision: 323634 $
phpMyAdmin-3.5.4-rc1-all-languages.7z
And this is the config.inc.php file in the PHPMyAdmin folder:
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Config file view and save screen
*
* @package PhpMyAdmin-setup
*/
if (!defined('PHPMYADMIN')) {
exit;
}
/**
* Core libraries.
*/
require_once './libraries/config/FormDisplay.class.php';
require_once './setup/lib/index.lib.php';
require_once './setup/lib/ConfigGenerator.class.php';
$config_readable = false;
$config_writable = false;
$config_exists = false;
check_config_rw($config_readable, $config_writable, $config_exists);
?><?php echo __('Configuration file') ?>
<?php display_form_top('config.php'); ?>
<input type="hidden" name="eol" value="<?php echo htmlspecialchars(PMA_ifSetOr($_GET['eol'], 'unix')) ?>" />
<?php display_fieldset_top('', '', null, array('class' => 'simple')); ?>
<textarea cols="50" rows="20" name="textconfig" id="textconfig" spellcheck="false"><?php
echo htmlspecialchars(ConfigGenerator::getConfigFile())
?></textarea>
<input type="submit" name="submit_download" value="<?php echo __('Download') ?>" class="green" />
<input type="submit" name="submit_save" value="<?php echo __('Save') ?>"<?php if (!$config_writable) echo ' disabled="disabled"' ?> />
<?php
display_fieldset_bottom_simple();
display_form_bottom();
?>
which part of these codes should I have to change?
You need to do two things to solve 1045 cannot log in to the mysql server:
One you have to map the changed login credentials in phpmyadmin's config.inc.php
and the second, you need to restart your web and MySQL servers.
PHP version is not the issue here..you need to go to phpmyadmin installation directory and find file config.inc.php and in that file put your current mysql password at line
$cfg['Servers'][$i]['user'] = 'root'; //mysql username here $cfg['Servers'][$i]['password'] = 'password'; //mysql password here