WampServer

I have no MySQL password set. I can log in on the console.

But I am trying to use adminer and phpmyadmin. Both require a password.

Any idea what to do?

Leave the password field blank if there is no password set.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Right-Click -> Help

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

I locked up the help before. Nothing in there explains that a password is needed.

I found nothing about Adminer in the help.


I have set
$cfg['Servers'][$i]['AllowNoPassword'] = true;

on phpMyAdmin.

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

Only after that I posted here.

Any other ideas?

> I have set
> $cfg['Servers'][$i]['AllowNoPassword'] = true;
This is the default value when installing Wampserver or a version of PhpMyAdmin.

Quote
Help -> Help PhpMyAdmin
-- PhpMyAdmin
When starting phpMyAdmin, you will be asked for a user name and password.
After installing Wampserver 3, the default username is "root" (without quotes) and there is no password, which
means that you must leave the form Password box empty.

If PhpMyAdmin explicitly asks for a password, it means you've already set one.

As for Adminer, I admit that the help file doesn't mention that a password is required.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

> As for Adminer, I admit that the help file doesn't
> mention that a password is required.

I found it for Adminer. You need to set
$AcceptEmptyPassword = true;


> If PhpMyAdmin explicitly asks for a password, it
> means you've already set one.

I have NOT set a password. I can now get in with Adminer without a password.

PhpMyAdmin still says: Login without a password is forbidden by configuration (see AllowNoPassword)

c:\wamp64\apps\phpmyadmin5.2.0\config.inc.php has

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

twice. One time for MYSQL (used) and one time for MariaDB (not used).