Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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
1  
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.