does phpMyAdmin AllowNoPassword works with MySQL databases?

Science & Technology
1

i am experiencing a problem of logging in to mysql databases using xamp sever …this is the error http://127.0.0.1/phpmyadmin/themes/dot.gif:
Log-in without a password is forbidden by configuration (see AllowNoPassword)…please help me guys

2

Go to your phpmyadmin config and set AllowNoPassword = True

I don’t know where the config file would be on your windows box, but on my Linux the file is at: /etc/phpmyadmin/config.inc.php

Line 40: $[cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

Change it to: $[cfg[‘Servers’][$i][‘AllowNoPassword’] = true;

1 Like
3

check thats my config.inc.php details …help me indicate the error

4

Your config looks OK.

5

You need to add your MySQL server password to the config file if you want PHPMyAdmin to autologin.

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

$cfg['Servers'][$i]['user'] = 'DB_USER';
$cfg['Servers'][$i]['password'] = 'DB_PASSWORD';

Also ensure have

$cfg['Servers'][$i]['auth_type'] = 'config';
6

On second thought, after looking at your config file, I think my response is a non-answer so please ignore it.

7

His config will work quite well if the root user has no password.

@Freddie ahmed, Confirm that your root user has no password for root@localhost, [email protected] and root@::1. If there is a defined password then add it to your config file.

8

this is what i am getting from trying ur method

9

@shadow-walker can u please check my configuration there top and tell me where my mistake is…coz to me i cant see any mistake

10

Why don’t you check first if your database user has a password configured. That could be the issue.

11

replace DB_USER and DP_PASSWORD with your actual db username and password.

12

First confirm your mysql credentials. Which username are you using? Does it have a password? Try logging in from another tool or from the command line and ensure that you have the right username/password.

13

tried all u said but it is all in vain …i have to reinstall the xampp server now

14

my.ini (my.cnf in Linux) skip-grant-tables

or if you want a Xampp specific config, try this:

http://stackoverflow.com/questions/24566453/resetting-mysql-root-password-with-xampp-on-localhost