我无法访问 XAMPP phpMyAdmin；它说:错误 MySQL 说:文档无法连接:无效设置 [英] I can't access XAMPP phpMyAdmin; it says: Error MySQL said: Documentation Cannot connect: invalid settings

问题描述

完整的错误信息:

Error
MySQL said: Documentation
Cannot connect: invalid settings. 
Connection for controluser as defined in your configuration failed.
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.

到目前为止，我一直在使用网站托管服务器；这可能弄乱了我的 xampp 连接.我的phpMyAdminconfig.in.php"文件设置如下:

I have been using a web hosting site sever so far; this may have messed up my xampp connection. My phpMyAdmin "config.in.php" file is set up as follows:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$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';

我可以在localhost:8080"运行我使用 xampp 创建的 php 代码，但我无法访问 mysql.我的数据库连接配置如下:

I am able to run the php codes that I have created using xampp at "localhost:8080", but I can't access mysql. My database connection configuration is as follows:

// Databse Connection Constants
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASS',','');
define('DB_NAME','gallery_db');

有人可以帮忙吗?谢谢.

Can anyone help? Thanks.

推荐答案

我在 StackOverflow 中找到了答案.在config.inc.php"中文件，我将配置"更改为cookie".以下是 StackOverflow 引用的答案:

I found the answer in StackOverflow. In "config.inc.php" file, I changed 'config' to 'cookie'. Here is the answer quoted from StackOverflow:

第 1 步:

找到phpMyAdmin的安装路径.

Locate phpMyAdmin installation path.

第 2 步:

在您喜欢的文本编辑器中打开 phpMyAdmin>config.inc.php.

Open phpMyAdmin>config.inc.php in your favourite text editor.

第 3 步:

搜索 $cfg['Servers'][$i]['auth_type'] = 'config';

将其替换为 $cfg['Servers'][$i]['auth_type'] = 'cookie';

这篇关于我无法访问 XAMPP phpMyAdmin；它说:错误 MySQL 说:文档无法连接:无效设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！