Skip to content

phpmyadmin log in without a password! #271

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
defeval opened this issue Mar 15, 2024 · 4 comments
Open

phpmyadmin log in without a password! #271

defeval opened this issue Mar 15, 2024 · 4 comments
Assignees

Comments

@defeval
Copy link

defeval commented Mar 15, 2024

Hi! phpmyadmin opens within the local network without entering a password. How to make access only by password?

@ostgardh
Copy link

Anyone know how enable password login?

@gilluc
Copy link

gilluc commented May 5, 2025

me too!

@blastg
Copy link

blastg commented May 16, 2025

Modify configuration: (nnnnnnnnnnn) is your phpmyadmin container id (view with docker ps)

docker cp nnnnnnnnnnn:/etc/phpmyadmin/config.inc.php config.inc.php
vi config.inc.php

modify from 'config'

   if (isset($_ENV['PMA_USER'])) {
        $cfg['Servers'][$i]['auth_type'] = 'config';

to 'cookie'

   if (isset($_ENV['PMA_USER'])) {
        $cfg['Servers'][$i]['auth_type'] = 'cookie';

then copy config file in container

docker cp config.inc.php nnnnnnnnnnn:/etc/phpmyadmin/config.inc.php

edit docker-compose.yml commenting out PMA_USER and PMA_PASSWORD

vi docker-compose.yml

  phpmyadmin:
    image: phpmyadmin
    container_name: "${COMPOSE_PROJECT_NAME}-phpmyadmin"
    links:
      - database
    environment:
      PMA_HOST: database
      PMA_PORT: 3306
        #PMA_USER: root
        #PMA_PASSWORD: ${MYSQL_ROOT_PASSWORD}

Restart phpmyadmin docker container
docker restart nnnnnnnnnnn

@ramzlab000
Copy link

Try removing the following variables from the docker-compose.yml and restart the docker.

PMA_USER
PMA_PASSWORD
MYSQL_USER
MYSQL_PASSWORD

It should prompt for username and password!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

6 participants