Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Click here to return to the 'Move MySQL to own User/Group?' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Move MySQL to own User/Group?
Authored by: MegaGrunt on May 24, '01 07:58:31PM

This article mentions moving the installed MySQL to it's own User/Group for extra security.

I know how to create a MySQL User/Group, but how do I move MySQL to it?

Or do I need to uninstall MySQL (how??) and re-install in the MySQL User?

[ Reply to This | # ]
Move MySQL to own User/Group?
Authored by: pfurbacher on May 31, '01 11:40:24PM
The file "manual.txt" which can be found in the "mysql-3.23.38/Docs" folder contains info on how to do this: ... 10. Change ownership of binaries to `root' and ownership of the data directory to the user that you will run `mysqld' as: shell> chown -R root /usr/local/mysql shell> chown -R mysql /usr/local/mysql/var shell> chgrp -R mysql /usr/local/mysql The first command changes the `owner' attribute of the files to the `root' user, the second one changes the `owner' attribute of the data directory to the `mysql' user, and the third one changes the `group' attribute to the `mysql' group. ... Earlier, it suggests creating both a "mysql" group and "mysql" user. I was able to create the user using the System Preferences | Users control panel, but have not been able to create the group (due to my lack of experience with Unix, I suppose).

[ Reply to This | # ]