linuxserver/mysql-workbench

​​
​ ​
​ ​
​ ​
​ ​
​ ​
​ ​
​ ​
​ ​
​​
​MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.
Supported Architectures
We utilise the docker manifest for multi-platform awareness. More information is available from docker here and our announcement here.
Simply pulling lscr.io/linuxserver/mysql-workbench should retrieve the correct image for your arch, but you can also pull specific arch images via tags.
The architectures supported by this image are:
Architecture
Tag
x86-64
latest
Application Setup
The application can be accessed at:
​http://yourhost:3000/​
By default the user/pass is abc/abc, if you change your password or want to login manually to the GUI session for any reason use the following link:
​http://yourhost:3000/?login=true​
Usage
To help you get started creating a container from this image you can either use docker-compose or the docker cli.
docker-compose (recommended, click here for more info)
1
---
2
version: "2.1"
3
services:
4
  mysql-workbench:
5
    image: lscr.io/linuxserver/mysql-workbench
6
    container_name: mysql-workbench
7
    environment:
8
      - PUID=1000
9
      - PGID=1000
10
      - TZ=Europe/London
11
    volumes:
12
      - /path/to/config:/config
13
    ports:
14
      - 3000:3000
15
    cap_add:
16
      - IPC_LOCK
17
    restart: unless-stopped
Copied!
docker cli (click here for more info)
1
docker run -d \
2
  --name=mysql-workbench \
3
  -e PUID=1000 \
4
  -e PGID=1000 \
5
  -e TZ=Europe/London \
6
  -p 3000:3000 \
7
  -v /path/to/config:/config \
8
  --cap-add="IPC_LOCK" \
9
  --restart unless-stopped \
10
  lscr.io/linuxserver/mysql-workbench
Copied!
Parameters
Docker images are configured using parameters passed at runtime (such as those above). These parameters are separated by a colon and indicate <external>:<internal> respectively. For example, -p 8080:80 would expose port 80 from inside the container to be accessible from the host's IP on port 8080 outside the container.
Ports (-p)
Parameter
Function
3000
Mysql Workbench desktop gui.
Environment Variables (-e)
Env
Function
PUID=1000
for UserID - see below for explanation
PGID=1000
for GroupID - see below for explanation
TZ=Europe/London
Specify a timezone to use EG Europe/London.
Volume Mappings (-v)
Volume
Function
/config
Users home directory in the container, stores program settings.
Miscellaneous Options
Parameter
Function
--cap-add=
Required for keyring functionality
Environment variables from files (Docker secrets)
You can set any environment variable from a file by using a special prepend FILE__.
As an example:
1
-e FILE__PASSWORD=/run/secrets/mysecretpassword
Copied!
Will set the environment variable PASSWORD based on the contents of the /run/secrets/mysecretpassword file.
Umask for running applications
For all of our images we provide the ability to override the default umask settings for services started within the containers using the optional -e UMASK=022 setting. Keep in mind umask is not chmod it subtracts from permissions based on it's value it does not add. Please read up here before asking for support.
User / Group Identifiers
When using volumes (-v flags), permissions issues can arise between the host OS and the container, we avoid this issue by allowing you to specify the user PUID and group PGID.
Ensure any volume directories on the host are owned by the same user you specify and any permissions issues will vanish like magic.
In this instance PUID=1000 and PGID=1000, to find yours use id user as below:
1
  $ id username
2
    uid=1000(dockeruser) gid=1000(dockergroup) groups=1000(dockergroup)
Copied!
Docker Mods
​​
​ ​
​​
We publish various Docker Mods to enable additional functionality within the containers. The list of Mods available for this image (if any) as well as universal mods that can be applied to any one of our images can be accessed via the dynamic badges above.
Support Info
Shell access whilst the container is running:
docker exec -it mysql-workbench /bin/bash
To monitor the logs of the container in realtime:
docker logs -f mysql-workbench
Container version number
docker inspect -f '{{ index .Config.Labels "build_version" }}' mysql-workbench
Image version number
docker inspect -f '{{ index .Config.Labels "build_version" }}' lscr.io/linuxserver/mysql-workbench
Versions
20.04.21: - Rebase on focal.
18.01.21: - Update libpython dependency.
26.03.20: - Initial release.