MySQL Forums
Forum List  »  Security

OS level security settings for MySQL base and datadir
Posted by: Eddie Jr. Panes
Date: July 22, 2008 03:25AM

Hi, I'm new to securing the base dir and data dir of mysql (installed from a tar.bz) and here are the directory settings:

drwxr-xr-x 2 mysql mysql 4096 Jan 14 2008 bin
-rwxr-xr-x 1 mysql mysql 801 Jan 14 2008 configure
-rw-r--r-- 1 mysql mysql 19071 Jan 11 2008 COPYING
drwxr-x--- 4 mysql mysql 4096 Jul 22 15:18 data
drwxr-xr-x 2 mysql mysql 4096 Jan 14 2008 docs
-rw-r--r-- 1 mysql mysql 5139 Jan 11 2008 EXCEPTIONS-CLIENT
drwxr-xr-x 3 mysql mysql 4096 Jan 14 2008 include
-rw-r--r-- 1 mysql mysql 8530 Jan 14 2008 INSTALL-BINARY
drwxr-xr-x 2 mysql mysql 4096 Jan 14 2008 lib
drwxr-xr-x 4 mysql mysql 4096 Jan 14 2008 man
drwxr-xr-x 9 mysql mysql 4096 Jan 14 2008 mysql-test
-rw-r--r-- 1 mysql mysql 1410 Jan 11 2008 README
drwxr-xr-x 2 mysql mysql 4096 Jan 14 2008 scripts
drwxr-xr-x 3 mysql mysql 4096 Jan 14 2008 share
drwxr-xr-x 5 mysql mysql 4096 Jan 14 2008 sql-bench
drwxr-xr-x 2 mysql mysql 4096 Jan 14 2008 support-files
drwxr-xr-x 2 mysql mysql 4096 Jan 14 2008 tests

Questions:
1. Should all these files and folders be owned by mysql?
2. are the file permissions enough or should i remove all Others from reading and executing?
3. Are there any folders or files that are not anymore necessary once the server goes into production and should be deleted?

TIA.

Options: ReplyQuote


Subject
Views
Written By
Posted
OS level security settings for MySQL base and datadir
5840
July 22, 2008 03:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.