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.
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
$ 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:
-itwill run an interactive session that can be terminated with CTRL+C.
--rmwill run a temporary session that will make sure to remove the container on exit.
-e DISPLAYsets the host display to the local machines display.
-v /tmp/.X11-unix:/tmp/.X11-unix:robind mounts the X11 socks on your local machine
to the containers and makes it read only.
-v ~/sqlyog:/sharedmounts a host directory as a data volume named shared
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