Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a non-root, portable distribution of MySQL for Linux?

I need to do some testing on a server that I do not have root access to.

share|improve this question
up vote 3 down vote accepted

If you are building from the tarbal, you would typically do something like

$ ./configure --prefix=$HOME

which after make has finished and you do make install will put all the bit in subdirectories of your home directory.

Then you may need to add $HOME/bin to your PATH environment variable and $HOME/lib to your LD_LIBRARY_PATH and make a few other adjustments like that.

share|improve this answer
That's for the install, but what about opening a service on a privileged port as non-root? – Benjamin Bannier Mar 3 '10 at 15:37
By default, 3306 is not a privileged port as it is upper than 1023. So no need to be root. – Dom Mar 3 '10 at 15:45
"what about opening a service on a privileged port as non-root?" Use a non-privileged port. As Dom says 3306 (the MySQL default) is fair game, and it is typical to substitute 8080 or 8888 for 80 when doing userspace httpd. – dmckee Mar 3 '10 at 16:34

XAMPP is a portable (W|L)AMP web server that can be put on a USB stick if you like.

share|improve this answer

You must log in to answer this question.