2054无法登陆mysql_phpmyadmin＃2054无法登录到mysql服务器

我是MySQL，Apache，PHP和phpMyAdmin的新手。我建立的第一台服务器是Windows Vista x32bit，并且它是成功的。然后，我尝试在另一台笔记本电脑上构建第二台服务器，它是Windows 7 x64bit，并以错误代码＃2054填充。我使用具有固定IP地址的'localhost'。我从.msi文件单独安装服务器，而不是软件包安装程序。phpmyadmin＃2054无法登录到mysql服务器

当我输入'root'和我的'密码'后，我点击'Go'，它弹出两条错误消息，一条是“＃2054无法登录到MySQL服务器”，另一条是“Connection for控制用户在您的配置中定义失败。“

我在网上搜索了很多资源，但运气不好。

我该如何解决这两个错误？

任何有用的信息。提前致谢。

下面是我的config.inc.php：

enter code here <?php

/* vim: set expandtab sw=4 ts=4 sts=4: */

/**

* phpMyAdmin sample configuration, you can use it as base for

* manual configuration. For easier setup you can use setup/

*

* All directives are explained in Documentation.html and on phpMyAdmin

* wiki .

*

* @package PhpMyAdmin

*/

/*

* This is needed for cookie based authentication to encrypt password in

* cookie

*/

$cfg['blowfish_secret'] = 'a8b7c6d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*

* Servers configuration

*/

$i = 0;

/*

* First server

*/

$i++;

/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* Server parameters */

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

/* Select mysql if your server does not have mysqli */

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['AllowNoPassword'] = false;

/*

* phpMyAdmin configuration storage settings.

*/

/* User used to manipulate with storage */

// $cfg['Servers'][$i]['controlhost'] = '';

$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';

$cfg['Servers'][$i]['controlpass'] = 'johan1234';

/* Storage database and tables */

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

$cfg['Servers'][$i]['relation'] = 'pma_relation';

$cfg['Servers'][$i]['table_info'] = 'pma_table_info';

$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'pma_column_info';

$cfg['Servers'][$i]['history'] = 'pma_history';

$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';

$cfg['Servers'][$i]['tracking'] = 'pma_tracking';

$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

$cfg['Servers'][$i]['recent'] = 'pma_recent';

/* Contrib/Swekey authentication */

// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

/*

* End of servers configuration

*/

/*

* Directories for saving/loading files from server

*/

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

/**

* Defines whether a user should be displayed a "show all (records)"

* button in browse mode or not.

* default = false

*/

//$cfg['ShowAll'] = true;

/**

* Number of rows displayed when browsing a result set. If the result

* set contains more rows, "Previous" and "Next".

* default = 30

*/

//$cfg['MaxRows'] = 50;

/**

* Use graphically less intense menu tabs

* default = false

*/

//$cfg['LightTabs'] = true;

/**

* disallow editing of binary fields

* valid values are:

* false allow editing

* 'blob' allow editing except for BLOB fields

* 'all' disallow editing

* default = blob

*/

//$cfg['ProtectBinary'] = 'false';

/**

* Default language to use, if not browser-defined or user-defined

* (you find all languages in the locale folder)

* uncomment the desired line:

* default = 'en'

*/

//$cfg['DefaultLang'] = 'en';

//$cfg['DefaultLang'] = 'de';

/**

* default display direction (horizontal|vertical|horizontalflipped)

*/

//$cfg['DefaultDisplay'] = 'vertical';

/**

* How many columns should be used for table display of a database?

* (a value larger than 1 results in some information being hidden)

* default = 1

*/

//$cfg['PropertiesNumColumns'] = 2;

/**

* Set to true if you want DB-based query history.If false, this utilizes

* JS-routines to display query history (lost by window close)

*

* This requires configuration storage enabled, see above.

* default = false

*/

//$cfg['QueryHistoryDB'] = true;

/**

* When using DB-based query history, how many entries should be kept?

*

* default = 25

*/

//$cfg['QueryHistoryMax'] = 100;

/*

* You can find more configuration options in Documentation.html

* or here: http://wiki.phpmyadmin.net/pma/Config

*/

?>

+0

你可以发布config.inc.php内容(文件位于\ xampp \ phpmyadmin)吗？ –

+0

Yea @IswantoSan是对的，发布配置，所以我们可以帮助你更好。 –

+0

抱歉。 config.inc.php现已发布。 –