yantis/sqlyog repository overview

⁠docker-sqlyog

SQLyog is the most powerful MySQL manager and admin tool.

SQLyog⁠ running with an optimized 32 bit Wine with an Arch Linux base. It is setup to work with the free community version though you can swap out the URLS in the Dockerfile and it will work with the paid version as well.

⁠Usage

The recommended way to run this container looks like this:

$ xhost +si:localuser:$(whoami)
$ mkdir ~/sqlyog
$ docker run -it --rm -e DISPLAY -v /tmp/.X11-unix:/tmp/.X11-unix:ro -v ~/sqlyog:/shared yantis/sqlyog

⁠Breakdown

$ xhost +si:localuser:yourusername

Allows your local user to access the xsocket. Change yourusername or use $(whoami) or $USER if your shell supports it.

$ mkdir ~/sqlyog

Make a directory that will be the shared folder between the host and the container This is where your ini configuration files will be as well as a place to import or export. Optionally, if you have an existing sqlyog.ini feel free to throw it in there and this will use that.

This directory can be any name or point to an existing directory.

This is Z:\shared in the container in Wine

$ docker run -it --rm -e DISPLAY -v /tmp/.X11-unix:/tmp/.X11-unix:ro -v ~/sqlyog:/shared yantis/sqlyog

This follows these docker's conventions:

• -it will run an interactive session that can be terminated with CTRL+C.
• --rm will run a temporary session that will make sure to remove the container on exit.
• -e DISPLAY sets the host display to the local machines display.
• -v /tmp/.X11-unix:/tmp/.X11-unix:ro bind mounts the X11 socks on your local machine to the containers and makes it read only.
• -v ~/sqlyog:/shared mounts a host directory as a data volume named shared

⁠Sample Script

I run this as a single command called sqlyog as if it were just another program on my box.

#!/bin/bash

xhost +si:localuser:$(whoami) >/dev/null
docker run \
        -d \
        -e DISPLAY \
        -v /tmp/.X11-unix:/tmp/.X11-unix:ro \
        -v $HOME/sqlyog:/shared \
        yantis/sqlyog >/dev/null