Starting a mysql server in my ${HOME}?

Solution 1:

To configure to compile in your directory:

./configure --prefix=/path/to/my/dir
make && make install

I believe you can specify your my.cnf file under your home directory.

/path/to/mysql/bin/mysqld_safe &

I haven't needed to do this, but it should work.

Solution 2:

You should definitely try MySQL Sandbox :

To run a simple MySQL service in your $HOME, you just need to :

• Download a MySQL binary tarball from MySQL's website
• run "make_sandbox /path/to/tarball.tar.gz"

You will get a complete MySQL server running in the directory of your choice.

The full documentation is there.

Solution 3:

Most probably your option would be to compile from source and setting the install directories to be in your home. And then you need to choose some port above 1024, as by default normal (non-root) users can not open ports below 1024.