Can I install Mysql binary as non-root?

zijian · 07-05-2009, 12:02 AM

If I can, could any one explain how to do so?
Thanks

TITiAN · 07-05-2009, 01:33 AM

You can usually install anything into your "home" directory, it's just a bit tricky.
I have added this to my file /etc/profile (using root):

Code:

if [ -d $HOME/.local/bin ] ; then
    export PATH="$PATH:$HOME/.local/bin"
fi
if [ -d $HOME/.local/lib ] ; then
    export LD_LIBRARY_PATH="$HOME/.local/lib:$LD_LIBRARY_PATH"
fi

(Be careful with the .local/lib directory, as viruses might be implemented in libs you install.)
Now, when you compile stuff from source, you should pass the parameter --prefix=$HOME/.local to the command ./configure.
When you have binary files you want to execute (which don't depend on installed data), put them in your ~/.local/bin directory. Then you can execute them from the terminal/console/shell/... or your desktop (tested on Gnome).

Any further questions?

j-ray · 07-05-2009, 06:03 AM

you probably have to edit the installing shell script as it will not install mysqld to your home directory by default. You can export the $PATH variable and $LD_LIBRARY_PATH variable the way TITiAN explained.

@TITiAN: zijian spoke of binaries, not of compiling sources. In case of mysqld it is usually better to take the binaries compiled with intel compiler.

Anyway I never tested what I said. Maybe you actually have to compile it...