up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
Belongs on serverfault.com, where sysadmins hang out. Maybe one of the moderators can come by and move this question for you. – Kevin M Mar 3 '10 at 16:40
@Kevin: I'm of mixed feelings on that. This question is about how you do admin like things when you are not possessed of administrator powers. From that point of view it is a users question. – dmckee Mar 3 '10 at 19:15
feedback

2 Answers

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.

link|improve this answer
That's for the install, but what about opening a service on a privileged port as non-root? – honk 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
feedback
up vote 1 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown