Adminer

Run adminer on top of docker

docker run -e "ADMINER_PLUGINS=dump-json" -p 8080:8080 -d adminer

Adding ADMINER_PLUGINS=dump-json will install dump-json adminer plugins. It will make you to be able export data to JSON formatted file.

Adminer using docker-compose with themes

adminer:
  image: adminer
  restart: always
  ports:
    - "7070:8080"
  environment:
    ADMINER_PLUGINS: "dump-json"
  volumes:
    - ./adminer.css:/var/www/html/adminer.css

Problem when connecting to MySQL without password The latest version adminer force your database enabled with password, but if your current mysql is not have password yet, you can set the password using this commands.

mysql -u root
> USE mysql;
> UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';
> FLUSH PRIVILEGES;
> quit

Adminer

Links