我无法访问phpMyAdmin - I am not able to access phpMyAdmin

I am not able to access phpMyAdmin

本文关键字：phpMyAdmin 访问 | 更新日期: 2023-09-27

当尝试访问phpMyAdmin时，我收到的错误信息是:欢迎访问phpMyAdmin

MySQL显示错误:Documentation

Cannot connect: invalid settings. 
Connection for controluser as defined in your configuration failed.

phpMyAdmin试图连接MySQL服务器，服务器拒绝连接。您应该检查配置中的主机、用户名和密码，并确保它们与MySQL服务器管理员给出的信息相对应。

检查第23行'xampp'phpMyAdmin'config.inc.php

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

所有的认证将在

下面

/* 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'] = '';

然后重启XAMPP

你也可以点击这里

xampp/根/xampp/cds.php

check line 4 to: mysql_connect("localhost","root","");
and line 78 to: if(!mysql_connect("localhost","root",""))

1。打开XAMPP根文件目录C:/XAMPP/phpmyadmin/config。并向下滚动到:

27   $cfg['Servers'][$i]['host'] = '127.0.0.1';
28   $cfg['Servers'][$i]['connect_type'] = 'tcp';

2。编辑第27行的"127.0.0.1"到localhost，并使用端口号，例如localhost:80。

结果:

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

3。Remove pma from， ['controluser'] = 'pma'.

结果:

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

最后尝试访问本地主机或刷新页面。幸福=]D