任何人都可以确认 phpMyAdmin AllowNoPassword 适用于 MySQL 数据库吗? [英] Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?

问题描述

我的本​​地 Apache 服务器上有一个 phpMyAdmin 版本.

I have a version of phpMyAdmin located on my local Apache server.

我试图在没有密码的情况下登录，但是 phpMyAdmin 不断发出警告:

I am trying to login without a password however phpMyAdmin keeps throwing the warning:

配置禁止无密码登录(见AllowNoPassword)

Login without a password is forbidden by configuration (see AllowNoPassword)

但是在我为 phpMyAdmin 设置的 config.php 文件中:

However in my config.php file for phpMyAdmin I have set:

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

所以我不知道为什么消息仍然出现.

So I don't know why the message is still appearing.

推荐答案

1. 复制 config.sample.inc.php 到 config.inc.php.

大多数情况下你会找到配置文件

In most cases you will find the config file

• 在 Linux 上:/etc/phpmyadmin/config.inc.php
• 在 Mac 上:/Library/WebServer/Documents/phpmyadmin/config.inc.php

如果您尝试以 root 身份登录，您的配置中应该包含以下几行:

If you are trying to log in as root, you should have the following lines in your config:

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

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

这篇关于任何人都可以确认 phpMyAdmin AllowNoPassword 适用于 MySQL 数据库吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！