任何人都可以证实，phpMyAdmin的AllowNoPassword可以与MySQL数据库？ [英] Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?

问题描述

我有phpMyAdmin的一个版本位于我的本地Apache服务器上。

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

我想没有密码的phpMyAdmin但扔不断警告登录：登录没有密码是由配置禁止（见AllowNoPassword）

I am trying to login without a password however phpMyAdmin keeps throwing the warning: 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.

推荐答案

我要检查第一个明显的，并询问是否你还记得复制你的 config.sample.inc 到 config.inc 。

I'm going to check the obvious first and ask if you remembered to copy your config.sample.inc to config.inc.

在Linux上的大多数情况下，你会发现这里的配置文件： /etc/phpmyadmin/config.inc.php

in most cases on linux you will find config files here: /etc/phpmyadmin/config.inc.php

第二，如果你想以root身份登录，你应该在你的配置如下几行：

Second, 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]['AllowNoPasswordRoot'] = true;

希望有所帮助。

Hope that helps.

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