Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases

Question

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

User · Answer

After a lot of trials I found the following solution.

This will work if you copied all phpmyadmin files in /var/www

go to your copied location of phpmyadmin folder in /var/www

copy the config.sample.inc.php file as config.inc.php

edit in config.inc.php the following line:

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

(In original file it was false, change it as true and save it.)

Then you will be able to login phpmyadmin without password.

User · Answer

cfg  Servers    i   AllowNoPassword     TRUE    yes the above answer is correct  but it s not secure  you can login root user directlyinto phpMyAdmin   If you want to create new user with password and give grant permission  execute the below command in MySQL on terminal   Login into your server on terminal       mysql   mysql gt  GRANT ALL PRIVILEGES ON     TO   user-name       IDENTIFIED BY   password    REQUIRE NONE WITH GRANT OPTION MAX QUERIES PER HOUR 0 MAX CONNECTIONS PER HOUR 0 MAX UPDATES PER HOUR 0 MAX USER CONNECTIONS 0

User · Answer

Make sure you don t add or uncomment the AllowNoPassword option after the  i   line      Uncomment the following to enable logging in to passwordless accounts         after taking note of the associated security risks        cfg  Servers    i   AllowNoPassword     TRUE

User · Answer

You might have made the same silly mistake that I did  by not removing the    making it a comment   The line should be like this  but not as a comment    cfg  Servers    i   AllowNoPassword     TRUE

User · Answer

Just in file  etc phpmyadmin config inc php  uncomment or add the line if not there     cfg  Servers    i   AllowNoPassword     TRUE    It works just Awesome   if you have any doubt restart apache   sudo  etc init d apache2 restart   Cheers

User · Answer

I had a same problem  and I solved my problem First go to config default php and change   cfg  Servers    i   AllowNoPassword     false    to    cfg  Servers    i   AllowNoPassword     true

User · Answer

I have the same problem here  then I reinstalled mysql and it worked   sudo apt-get install mysql-server mysql-common mysql-client

User · Answer

I tested the statement    cfg  Servers    i   AllowNoPasswordRoot     true     It did not work out for me   Instead    cfg  Servers    i   AllowNoPassword     true     worked    Thanks

User · Answer

Others may find  as I did   working in OS X 10 10 1  that the situation for MAMP PRO  at least in the current release  3 0 7 3  is different   All my attempts to apply the remedies suggested here failed  Upon examining the PHP error log I discovered that the index php that is operating  in  Libary Application Support appsolute MAMP PRO index php -- at line 43  is deciding NOT to go to the config inc php that is discussed here  at  Applications MAMP bin phpMyAdmin config inc php  but rather to  Library Application Support appsolute MAMP PRO phpMyAdmin config inc php    Furthermore  there is no such file there  after a  successful  install of MAMP PRO   so I m stuck with the error  and furtherfuthermore  every time I try to put the correct file there  when I restart MAMP PRO  it is not there anymore - something is automatically refreshed to eliminate the config inc php I m putting there  My workaround for now is to do this in MAMP instead of MAMP PRO

User · Answer

I had to install MariaDB  I am using OpenSUSE LINUX Leap 15 and had to execute these commands   sudo zypper update sudo zypper install mariadb mariadb-client mariadb-tools sudo systemctl start mysql sudo systemctl enable mysql   enable auto start at boot time3 sudo mysql secure installation   Source

User · Answer

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   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

User · Answer

After lots of struggle I found here you go   open folder  - gt  xampp then open    - gt  phpmyadmin finally open - gt  config inc   cfg  blowfish secret            YOU MUST FILL IN THIS FOR COOKIE AUTH       Put SHA256 inside single quotations like this one  830bbca930d5e417ae4249931838e2c70ca0365044268fa0ede75e33aff677de  cfg  blowfish secret      830bbca930d5e417ae4249931838e2c70ca0365044268fa0ede75e33aff677de     I found this when I was downloading updated version of phpmyadmin  I wish this solution help you

User · Answer

Yes not working  I spent whole day with this stupid phpMyAdmin  Just add a new user with a password  1 - Login to mysql or mariadb mysql -u root -p  2 - Run these SQL commands to create a new user with all permissions  or grant your custom permissions   CREATE USER  someone   localhost  IDENTIFIED BY  password   GRANT ALL PRIVILEGES ON     TO  someone   localhost   FLUSH PRIVILEGES    2 - Go to  etc phpMyAdmin config inc php and change this    cfg  Servers    i   user               someone    cfg  Servers    i   password           password     WARNING  This config is for localhost development server only  If you re running a production server you must use strong credentials and not setting user pass in config inc php

User · Answer

It works  just thought this would be helpful to someone in the future   If you are working with MAMP  as a security measure  the  cfg  Servers    i   AllowNoPassword     true  usually will be missing in the config inc php file so if you want to use phpMyAdmin without a password for root then simply add it preferably after the  cfg  Servers    i   AllowDeny    rules     array    statement    Then Restart your server just to be sure and you will be good to go

User · Answer

According to this  https   www simplified guide phpmyadmin enable-login-without-password  This  cfg  Servers    i   AllowNoPassword     TRUE  should be added twice in  etc phpmyadmin config inc php  if   empty  dbname            other configuration options      cfg  Servers    i   AllowNoPassword     TRUE         it should be placed before the following line      i          other configuration options  cfg  Servers    i   AllowNoPassword     TRUE

[php] Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?

Examples related to php

Examples related to mysql

Examples related to apache

Examples related to passwords

Examples related to phpmyadmin