Connection for control user as defined in your configuration failed. xampp(配置中定义的控制用户连接失败.xampp)
问题描述
当我尝试卸载 xampp 并重新安装 xampp 时,当我转到 phpmyadmin 时收到以下错误消息
when i tried to uninstall xampp and reinstall xampp.I received below error message when i go phpmyadmin
需要帮助和指导来解决它.谢谢
Need help and guide to solve it .thanks
错误
MySQL 说:文档
您的配置中定义的 controluser 连接失败.
Connection for controluser as defined in your configuration failed.
phpMyAdmin 尝试连接 MySQL 服务器,服务器拒绝连接.您应该检查配置中的主机、用户名和密码,并确保它们与 MySQL 服务器管理员提供的信息相对应.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
推荐答案
基本上这里发生的事情是你的 [ .../phpMyadmin/config.inc.php] 文件中有错误的凭据.如果你有,就会发生这种情况安装了另一个mysql实例,你在这个文件中使用的用户名和密码不同.你必须更改上面文件中的用户名和密码才能匹配.
Basically what is happening here is that you have wrong credentials in your[ .../phpMyadmin/config.inc.php] file .This occurs if you have another mysql instance installed and the username and the passowrd that you use in this file is different.You have to change the username and the password in the above file to match.
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root'; //Change this to your values
$cfg['Servers'][$i]['password'] = 'root'; //Change this to your values
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
这篇关于配置中定义的控制用户连接失败.xampp的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!
本文标题为:配置中定义的控制用户连接失败.xampp
基础教程推荐
- 如何在 XAMPP 上启用 mysqli? 2021-01-01
- 在 yii2 中迁移时出现异常“找不到驱动程序" 2022-01-01
- 如何在 Symfony 和 Doctrine 中实现多对多和一对多? 2022-01-01
- Doctrine 2 - 在多对多关系中记录更改 2022-01-01
- HTTP 与 FTP 上传 2021-01-01
- 在 CakePHP 2.0 中使用 Html Helper 时未定义的变量 2021-01-01
- 找不到类“AppHttpControllersDB",我也无法使用新模型 2022-01-01
- phpmyadmin 错误“#1062 - 密钥 1 的重复条目‘1’" 2022-01-01
- PHP 守护进程/worker 环境 2022-01-01
- 使用 PDO 转义列名 2021-01-01