我无法访问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连接.我的phpMyAdmin"config.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"文件中，我将"config"更改为"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屋！