错误#1045-无法登录到MySQL服务器-> phpmyadmin [英] Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin

问题描述

我们已在运行IIS 7.0的Windows计算机上安装了PHPMyAdmin.
我们可以使用命令行连接到MySQL，但是我们不能使用PHPMyAdmin连接.
显示的错误是:Error #1045 Cannot log in to the MySQL server.
有人可以帮忙吗?

We have installed PHPMyAdmin on a windows machine running IIS 7.0.
We are able to connect to MySQL using command-line, But we are not able to connect using PHPMyAdmin.
The error displayed is: Error #1045 Cannot log in to the MySQL server.
Can somebody please help?

PHP Version 5.4.0
mysqlnd 5.0.10 - 20111026 - $Revision: 323634 $
phpMyAdmin-3.5.4-rc1-all-languages.7z

PHP Version 5.4.0
mysqlnd 5.0.10 - 20111026 - $Revision: 323634 $
phpMyAdmin-3.5.4-rc1-all-languages.7z

我没有成功跟随下面的链接，这意味着我更改了密码，但是phpmyadmin仍然存在该错误...
C.5.4.1.1.重置根密码:Windows系统

EDIT :
I followed the link below with no success, mean i changed that password but phpmyadmin still has that error...
C.5.4.1.1. Resetting the Root Password: Windows Systems

在堆栈中也没有类似下面的线程:
随机错误:#1045无法登录到MySQL服务器
但是那个错误不是随机的->我总是有那个错误...

Also there is thread like below in stack with no help :
Random error: #1045 Cannot log in to the MySQL server
but that error is not random -> i always have that error...

这是phpmyadmin文件夹中的config.inc.php文件:

And this is config.inc.php file in 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);
?>
<h2><?php echo __('Configuration file') ?></h2>
<?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')); ?>
<tr>
    <td>
        <textarea cols="50" rows="20" name="textconfig" id="textconfig" spellcheck="false"><?php
            echo htmlspecialchars(ConfigGenerator::getConfigFile())
        ?></textarea>
    </td>
</tr>
<tr>
    <td class="lastrow" style="text-align: left">
        <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"' ?> />
    </td>
</tr>
<?php
display_fieldset_bottom_simple();
display_form_bottom();
?>

我应该在其中哪些部分更改代码?

where part of these codes should i change?

谢谢.

推荐答案

在按照您在帖子中提到的链接进行操作之后，您还需要做另外两件事:

You need to do two additional things after following the link that you have mentioned in your post:

必须在phpmyadmin的 config.inc.php

One have to map the changed login cridentials in phpmyadmin's config.inc.php

第二，您需要重新启动Web和mysql服务器.

and second, you need to restart your web and mysql servers..

php版本不是这里的问题..您需要转到 phpmyadmin 安装目录并找到文件config.inc.php，然后在该文件中将您当前的mysql密码放在

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

这篇关于错误#1045-无法登录到MySQL服务器-> phpmyadmin的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！