沃梦达 / 编程问答 / php问题 / 正文

谁能确认 phpMyAdmin AllowNoPassword 适用于 MySQL 数据库?

Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?(谁能确认 phpMyAdmin AllowNoPassword 适用于 MySQL 数据库?)

本文介绍了谁能确认 phpMyAdmin AllowNoPassword 适用于 MySQL 数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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

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

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

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. Copy config.sample.inc.php to config.inc.php.

    In most cases you will find the config file

    • on linux: /etc/phpmyadmin/config.inc.php
    • on mac: /Library/WebServer/Documents/phpmyadmin/config.inc.php
  2. 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;

这篇关于谁能确认 phpMyAdmin AllowNoPassword 适用于 MySQL 数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:谁能确认 phpMyAdmin AllowNoPassword 适用于 MySQL 数据库?

基础教程推荐