disable auto login

[mictadlo]

Hi,
I have the following phpmyadmin entries in my docker-compose.yml file:

phpmyadmin:
  image: phpmyadmin/phpmyadmin
  restart: always
  links:
    - db
  ports:
    - 8183:80
  environment:
    PMA_USER: root
    PMA_PASSWORD: xxx
    #PMA_ARBITRARY: 1

When I open phpmyadmin is automatically log in.

How is it possible to disable auto login?

Thank you in advance,

Michal

[nijel]

Just don't specify PMA_PASSWORD and PMA_USER ;-).

[ghost]

Just don't specify PMA_PASSWORD and PMA_USER ;-).

but then this happens

Cannot connect: invalid settings.
mysqli_real_connect(): (HY000/1045): Access denied for user ''@'phpmyadmin.compose_default' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

[pesovski]

Just don't specify PMA_PASSWORD and PMA_USER ;-).

but then this happens

Cannot connect: invalid settings.
mysqli_real_connect(): (HY000/1045): Access denied for user ''@'phpmyadmin.compose_default' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Hi. Did you solve this? I am experiencing the same issue now.

[williamdes]

Hi @pesovski
Could you send your docker compose file?

[pesovski]

I just fixed it actually. Or it fixed itself.

Having PMA_USER and PMA_PASSWORD doesn't ask for login.

When I removed these 2 environment variables, I got the same error as @ghost: Cannot connect: invalid settings.

Once you wrote I tried again, didn't change anything and it happened to be working. Thanks.

[charlesc-ai]

In order to disable auto login for Phpmyadmin, you should remove PMA_USER and PMA_PASSWORD, just keep PMA_HOSTS,
then the phpmyadmin will ask for login to access the database.

[CyberHacky-zz]

Solution :

Add Login Panel to PHPMyadmin

1. First create Docker using PMA_USER: root and PMA_PASSWORD: secret
2. Now Compose the docker and go to the User Account menu.
3. Click on the Username which you have created using the PMA_USER command
4. Change the Password which you want and save it
5. Now Stop Docker Service
6. Remove Both Line PMA_USER and PMA_PASSWORD from the docker-compose.yml file
7. Now run Docker and you can log in with updated password with the same username