Stan P. van de Burgt writes:
> After installing MySQL on a workgroup server I was left with some questions
> that I didn't bother about when installing on my own machine:
>
> 1. Should the MySQL executables be owned by root? Or is it better to make a
> new user 'mysql' for that purpose? If so: is there an easy way to chown all
> installed files and directories?
Hi Stan,
It depends. Often the executables are owned by that user who installed
them. Which is the root in the most cases if the files are installed
in common directories like /usr/bin etc. And this is ok. Of course you
can change them to be owned by someone else, but it only changes the
rights who can remove, do chmod etc. to them. It doesn't have any
meaning for that who executes them. Of course if you have persons that
are working with MySQL and they need to move, remove, install mysql
files, you can do a group who has the group rights to mysql
files. 'chgrp -R mysql *' changes the group owner to 'mysql', if you
have that one, recursively starting from the directory you are
standing at. Be careful not to destroy your whole system if you run
the above as root (be sure to be in the right place).
> 2. What files and directories are installed by typing 'make install'? The
> output of make just flashes off the screen.
These files are installed under the directory that you have choses
with the configure --prefix=... and --exec-prefix=...
By default, under /usr/local
There are:
bin:
comp_err*
isamchk*
isamlog*
msql2mysql*
mysql*
mysql_fix_privilege_tables*
mysql_install_db*
mysql_setpermission*
mysql_zap*
mysqlaccess*
mysqladmin*
mysqlbug*
mysqldump*
mysqlimport*
mysqlshow*
perror*
replace*
resolveip*
safe_mysqld*
include/mysql:
chardefs.h
dbug.h
errmsg.h
history.h
keymaps.h
m_ctype.h.in
m_string.h
my_list.h
my_sys.h
mysql.h
mysql_com.h
mysql_version.h
mysqld_error.h
readline.h
tilde.h
info:
dir
mysql.info
lib/mysql:
libdbug.a
libheap.a
libmerge.a
libmysqlclient.a
libmysqlclient.la*
libmystrings.a
libmysys.a
libnisam.a
libexec:
mysqld*
man/man1:
mysql.1
Everything under
share/mysql:
Everything under
sql-bench:
var:
marvel.pid
mysql/
test/
And eveything under mysql/ and test/ of the above.
> 3. When moving to a new version, can I just type 'make install' again or
> should I remove the previous installation first? Is there a clean way to do
> that?
>
make distclean.
> - Stan
>
> --
> Stan P. van de Burgt stan@stripped (0x853296C5)
> DMO, P.O. box 1248, 3500 AE, Utrecht, the Netherlands
>
Regards,
- Jani
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
