Hi David, all,
David Favor wrote:
> [[...]]
>
> You can see this easily by doing the build + test as root.
sorry - I (for example) would never have dreamt of someone doing the
build as the "root" user.
While there are things for which you need root privileges
(most notable: installation, changing system files and directories),
this should *never* be necessary for a build (compile + link run),
for any product (not just MySQL).
If some file or directory name is mistyped, a compiler or linker run by
"root" could accidentally overwrite some important file and break your
system.
Specifically for MySQL, we discourage users from running the database as
"root":
If you do this, and the database privileges allow some user to access
files in arbitrary directories, s/he could easily compromise the system.
So not running the MySQL server as the root user is one step towards
better security on your system.
Regards,
Joerg
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com