Installing multiple MySQL versions on the same Linux with mysql-sandbox
Ubuntu has a package
mysql-sandbox that lets you install multiple MySQL versions into your user home:
sudo apt install mysql-sandbox # Download mysql distribution .tar.gz from mysql.com # You must choose "Generic Linux" instead of "Ubuntu" so you get a .tar.gz instead of .deb make_sandbox mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
On older distributions,
make_sandbox might be
This will install this version into
/~/sandboxes/msb_5_7.21. The folder includes a command to start the MySQL daemon for that sandbox. It listens to a non-standard port, so it can run in parallel with your regular MySQL installation.
Note the console output when you install a sandbox. It will show the non-standard port and the username (default
root) and password (default
msandbox). When working on a Rails project, you need to paste all of that into your
Connecting to a sandbox
mysql --user=root --password=msandbox --host=127.0.0.1 --port=1234
1234 with the port for the Sandbox.