The MySQL Sandbox

PURPOSE

This package is a sandbox for testing features under MySQL from 3.23 to 5.1. It will install one node under your home directory, and it will provide some useful commands to start, use and stop this sandbox.

With this package you can play with MySQL 5.x without need of using other computers. The server installed in the sandbox use non-standard ports and sockets, so that they won't interfere with existing MYSQL installations.

NEW! a detailed Tutorial is now available

REQUIREMENTS

Linux or FreeBSD operating system (it may work in other *NIX OSs, but has not been tested)
MySQL 5.0.19, 5.1.7 or later
Perl 5.8.1 or later (for installation only)
bash (or tcsh) shell

INSTALLATION

Unpack the necessary MySQL binaries somewhere under your home directory, and give it a convenient name (e.g. $HOME/binaries/5.1.10 )

Download the latest MySQL Sandbox package.

Unpack the distribution package in one empty directory and run the install script. For example:

$ ./install.pl -f sandbox.conf --basedir=$HOME/binaries/5.1.10

You can create the data directory in three ways:

using the duplied archive, with pre-defined users and passwords install.pl --datadir_from=archive
using mysql_install_db script. In this case, you need to create username and passwords manually, and eventually replace them in the sandbox scripts. install.pl --datadir_from=script
copying from an already existing directory (you need to have the necessary privileges to read fies from the origin) install.pl --datadir_from=dir:/usr/local/mysql/data/mysql

If needed, modify sandbox.conf to change default installation options.

To see the available options, run ./install.pl --help

USAGE

Change directory to the newly created one (default: $HOME/mysql_sandbox)

Start the server

./start.sh

Stop the server

./start.sh

use a client with the sandbox server:

./use.sh

DATABASE USERS

There are 2 database users installed by default:

 +-----------------+-------------+-------------------------------+
 |  user name      | password    | privileges                    |
 +-----------------+-------------+-------------------------------+
 |  root@localhost | datacharmer | all on *.* with grant option  |
 |  datacharmer@%  | datacharmer | all on *.*                    |
 +-----------------+-------------+-------------------------------+

PORTS AND SOCKETS

(note: ports can be overriden using -p option during install)

 +--------+-----------------------------+
 | port   | socket                      |
 +--------+-----------------------------+
 |  3310  | /tmp/mysql_sandbox3310.sock |
 +--------+-----------------------------+

LEGAL NOTICE

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA