最近安装了XAMPP和卡上的“控制用户连接失败”

问题描述:

我最近安装的XAMPP,但是当我点击XAMPP的MySQL管理员按钮,它不是重定向MySQL中,而是在问我的用户名和密码,给我这个错误最近安装了XAMPP和卡上的“控制用户连接失败”

如在配置中定义控制用户

连接失败

我知道默认的用户名和密码是ROOT“”但它没有帮助。我认为控制用户存在问题。如何解决这个问题?

这是我在登录后获得:

this is what I'm getting after logging in

这是我的config.inc.php

<?php 
/* 
* This is needed for cookie based authentication to encrypt password in 
* cookie 
*/ 
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */ 

/* 
* Servers configuration 
*/ 
$i = 0; 

/* 
* First server 
*/ 
$i++; 

/* Authentication type and info */ 
$cfg['Servers'][$i]['auth_type'] = 'cookie'; 
$cfg['Servers'][$i]['user'] = 'root'; 
$cfg['Servers'][$i]['password'] = ''; 
$cfg['Servers'][$i]['extension'] = 'mysqli'; 
$cfg['Servers'][$i]['AllowNoPassword'] = true; 
$cfg['Lang'] = ''; 

/* Bind to the localhost ipv4 address and tcp */ 
$cfg['Servers'][$i]['host'] = '127.0.0.1'; 
$cfg['Servers'][$i]['connect_type'] = 'tcp'; 

/* User for advanced features */ 
$cfg['Servers'][$i]['controluser'] = 'root'; 
$cfg['Servers'][$i]['controlpass'] = ''; 

/* Advanced phpMyAdmin features */ 
$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]['designer_coords'] = 'pma__designer_coords'; 
$cfg['Servers'][$i]['tracking'] = 'pma__tracking'; 
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; 
$cfg['Servers'][$i]['recent'] = 'pma__recent'; 
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; 
$cfg['Servers'][$i]['users'] = 'pma__users'; 
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; 
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; 
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; 
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; 
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; 
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; 
$cfg['Servers'][$i]['favorite'] = 'pma__favorite'; 

/* 
* End of servers configuration 
*/ 

?> 
s 

如果你希望密码是根

我相信你需要改变这一行:

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

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

或者如果不行,请尝试更改

$cfg['Servers'][$i]['password'] = ''; 

$cfg['Servers'][$i]['password'] = 'root'; 

错误特别提到控制用户的,所以它应该是第一。

+0

已尝试这两件事,但它没有帮助。一位专业人士建议我卸载xampp并安装以前的版本,它会解决我的问题吗?目前的版本是3.2.2 –

+0

我不知道我自己,但编号说试试看。 –