I'm very new to mysql. Just learning. I'm trying to correctly set up the
permissions for the files under the mysql/ directory.  I've included a
list. I would appreciate it if some one could look over it and recommend
changes. Thank you.

Michael Sellers
------------------------------------------------------------------------

/usr/local/mysql
################
total 4752
drwxr-xr-x    2 root     root         4096 Jun 19 00:05 bin
-rw-r--r--    1 root     mysqlgrp   122213 Jun  3 05:39 ChangeLog
-rwxr-xr-x    1 root     mysqlgrp      773 Jun  9 08:13 configure
-rw-r--r--    1 root     mysqlgrp    19106 Jun  8 09:57 COPYING
-rw-r--r--    1 root     mysqlgrp    47577 Jun  8 09:57 COPYING.LIB
drwxr-x---    4 root     mysqlgrp     4096 Jun 19 23:02 data
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 include
-rw-r--r--    1 root     mysqlgrp   147458 Jun  8 09:57 INSTALL-BINARY
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 lib
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 man
-rw-r--r--    1 root     mysqlgrp  2336774 Jun  8 09:56 manual.html
-rw-r--r--    1 root     mysqlgrp    85892 Jun  8 09:56 manual_toc.html
-rw-r--r--    1 root     mysqlgrp  2021070 Jun  8 09:56 manual.txt
drwxr-xr-x    6 root     mysqlgrp     4096 Jun  9 08:13 mysql-test
-rw-r--r--    1 root     mysqlgrp     1976 Jun  3 05:39 README
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 scripts
drwxr-xr-x    3 root     mysqlgrp     4096 Jun  9 08:13 share
drwxr-xr-x    7 root     mysqlgrp     4096 Jun  9 08:13 sql-bench
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 support-files
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 tests


/usr/local/mysql/bin
################
total 15696
-rwxr-xr-x    1 root     root       619808 Jun  9 08:13 comp_err
-rwxr-xr-x    1 root     root       749524 Jun  9 08:13 isamchk
-rwxr-xr-x    1 root     root         1474 Jun  9 08:13 msql2mysql
-rwxr-xr-x    1 root     root       828488 Jun  9 08:13 myisamchk
-rwxr-xr-x    1 root     root       747244 Jun  9 08:13 myisampack
-rwxr-xr-x    1 root     root       630504 Jun  9 08:13
my_print_defaults
-rwxr-xr-x    1 root     root       759028 Jun  9 08:13 mysql
-rwxr-xr-x    1 root     root       111547 Jun  9 08:13 mysqlaccess
-rwxr-xr-x    1 root     root         1702 Jun  3 05:39 mysqlaccess.conf
-rwxr-xr-x    1 root     root       601236 Jun  9 08:13 mysqladmin
-rwxr-xr-x    1 root     root       615144 Jun  9 08:13 mysqlbinlog
-rwxr-xr-x    1 root     root         9731 Jun  9 08:13 mysqlbug
-rwxr-xr-x    1 root     root       595304 Jun  9 08:13 mysqlcheck
-rwxr-xr-x    1 root     root         3144 Jun  9 08:13 mysql_config
-rwxr-xr-x    1 root     root         2976 Jun  9 08:13
mysql_convert_table_format
-rwxr-xr-x    1 root     root      3835316 Jun  9 08:13 mysqld
-rwxr-xr-x    1 root     root        18415 Jun  9 08:13 mysqld_multi
-rwxr-xr-x    1 root     root        96797 Jun  9 08:13 mysqld.sym.gz
-rwxr-xr-x    1 root     root       609244 Jun  9 08:13 mysqldump
-rwxr-xr-x    1 root     root         4986 Jun  9 08:13 mysqldumpslow
-rwxr-xr-x    1 root     root         2654 Jun  9 08:13 mysql_find_rows
-rwxr-xr-x    1 root     root         4437 Jun  9 08:13
mysql_fix_privilege_tables
-rwxr-xr-x    1 root     root        27610 Jun  9 08:13 mysqlhotcopy
-rwxr-xr-x    1 root     root       591904 Jun  9 08:13 mysqlimport
-rwxr-xr-x    1 root     root        15255 Jun  9 08:13
mysql_setpermission
-rwxr-xr-x    1 root     root       592800 Jun  9 08:13 mysqlshow
-rwxr-xr-x    1 root     root       614688 Jun  9 08:13 mysqltest
-rwxr-xr-x    1 root     root         3104 Jun  9 08:13 mysql_zap
-rwxr-xr-x    1 root     root       707928 Jun  9 08:13 pack_isam
-rwxr-xr-x    1 root     root       625528 Jun  9 08:13 perror
-rwxr-xr-x    1 root     root       633800 Jun  9 08:13 replace
-rwxr-xr-x    1 root     root       625204 Jun  9 08:13 resolveip
-rwxr-xr-x    1 root     root       624232 Jun  9 08:13
resolve_stack_dump
-rwxr-xr-x    1 root     root         8463 Jun 19 00:03 safe_mysqld


/usr/local/mysql/data
################
total 44
-rw-r--r--    1 mysqladm mysqlgrp     3527 Jun 20 19:22 laptop.err
-rw-rw----    1 root     mysqlgrp    29777 Jun 20 19:22 log.0000000001
drwxr-x---    2 root     mysqlgrp     4096 Jun 17 11:51 mysql
drwxr-x---    2 root     mysqlgrp     4096 Jun 17 14:08 test


/usr/local/mysql/include
################
total 400
-rw-r--r--    1 root     mysqlgrp    21021 Jun  9 08:07 config.h
-rw-r--r--    1 root     mysqlgrp     9394 Jun  3 05:39 config-win.h
-rw-r--r--    1 root     mysqlgrp     3445 Jun  3 05:39 dbug.h
-rw-r--r--    1 root     mysqlgrp     2082 Jun  3 05:39 errmsg.h
-rw-r--r--    1 root     mysqlgrp     1819 Jun  3 05:39 ft_global.h
-rw-r--r--    1 root     mysqlgrp     4799 Jun  3 05:39 getopt.h
-rw-r--r--    1 root     mysqlgrp    31380 Jun  3 05:39 global.h
-rw-r--r--    1 root     mysqlgrp     2364 Jun  3 05:39 hash.h
-rw-r--r--    1 root     mysqlgrp     5599 Jun  3 05:39 heap.h
-rw-r--r--    1 root     mysqlgrp     5864 Jun  3 05:39 m_ctype.h
-rw-r--r--    1 root     mysqlgrp     3195 Jun  3 05:39 merge.h
-rw-r--r--    1 root     mysqlgrp     7594 Jun  3 05:39 m_string.h
-rw-r--r--    1 root     mysqlgrp     2098 Jun  3 05:39 my_alarm.h
-rw-r--r--    1 root     mysqlgrp    10725 Jun  3 05:39 my_base.h
-rw-r--r--    1 root     mysqlgrp     1876 Jun  3 05:39 my_bitmap.h
-rw-r--r--    1 root     mysqlgrp    21021 Jun  9 08:07 my_config.h
-rw-r--r--    1 root     mysqlgrp     3294 Jun  3 05:39 my_dir.h
-rw-r--r--    1 root     mysqlgrp    31380 Jun  3 05:40 my_global.h
-rw-r--r--    1 root     mysqlgrp    14025 Jun  3 05:39 myisam.h
-rw-r--r--    1 root     mysqlgrp     3445 Jun  3 05:39 myisammrg.h
-rw-r--r--    1 root     mysqlgrp     9292 Jun  3 05:39 myisampack.h
-rw-r--r--    1 root     mysqlgrp     1579 Jun  3 05:39 my_list.h
-rw-r--r--    1 root     mysqlgrp     2696 Jun  3 05:39 my_net.h
-rw-r--r--    1 root     mysqlgrp     1206 Jun  3 05:39 my_no_pthread.h
-rw-r--r--    1 root     mysqlgrp     1712 Jun  3 05:39 my_nosys.h
-rw-r--r--    1 root     mysqlgrp    21550 Jun  3 05:39 my_pthread.h
-rw-r--r--    1 root     mysqlgrp     8556 Jun  3 05:39 mysql_com.h
-rw-r--r--    1 root     mysqlgrp     8188 Jun  3 05:39 mysqld_error.h
-rw-r--r--    1 root     mysqlgrp    10787 Jun  3 05:39 mysql.h
-rw-r--r--    1 root     mysqlgrp      552 Jun  9 08:07 mysql_version.h
-rw-r--r--    1 root     mysqlgrp     1866 Jun  3 05:39 mysys_err.h
-rw-r--r--    1 root     mysqlgrp    25577 Jun  3 05:39 my_sys.h
-rw-r--r--    1 root     mysqlgrp     2479 Jun  3 05:39 my_tree.h
-rw-r--r--    1 root     mysqlgrp     6868 Jun  3 05:39 nisam.h
-rw-r--r--    1 root     mysqlgrp     2140 Jun  3 05:39 queues.h
-rw-r--r--    1 root     mysqlgrp     5869 Jun  3 05:39 raid.h
-rw-r--r--    1 root     mysqlgrp     1605 Jun  3 05:39 sslopt-case.h
-rw-r--r--    1 root     mysqlgrp     1296 Jun  3 05:39
sslopt-longopts.h
-rw-r--r--    1 root     mysqlgrp     1235 Jun  3 05:39 sslopt-usage.h
-rw-r--r--    1 root     mysqlgrp     1013 Jun  3 05:39 sslopt-vars.h
-rw-r--r--    1 root     mysqlgrp     4907 Jun  3 05:39 t_ctype.h
-rw-r--r--    1 root     mysqlgrp     2782 Jun  3 05:39 thr_alarm.h
-rw-r--r--    1 root     mysqlgrp     3907 Jun  3 05:39 thr_lock.h
-rw-r--r--    1 root     mysqlgrp     3024 Jun  3 05:39 violite.h


/usr/local/mysql/lib
################
total 1756
-rw-r--r--    1 root     mysqlgrp    10774 Jun  9 08:10 libdbug.a
-rw-r--r--    1 root     mysqlgrp   879270 Oct 24  2001 libmygcc.a
-rw-r--r--    1 root     mysqlgrp   275060 Jun  9 08:08 libmysqlclient.a
-rw-r--r--    1 root     mysqlgrp   280630 Jun  9
08:08libmysqlclient_r.a
-rw-r--r--    1 root     mysqlgrp   120380 Jun  9 08:10 libmystrings.a
-rw-r--r--    1 root     mysqlgrp   199264 Jun  9 08:10 libmysys.a


/usr/local/mysql/man
################
total 68
-rwxr-xr--    1 root     mysqlgrp     3875 Jun  3 05:39 isamchk.1
-rw-r--r--    1 root     mysqlgrp     1627 Jun  3 05:39 isamlog.1
-rw-r--r--    1 root     mysqlgrp     3440 Jun  3 05:39 mysql.1
-rwxr-xr--    1 root     mysqlgrp     2796 Jun  3 05:39 mysqlaccess.1
-rwxr-xr--    1 root     mysqlgrp     4462 Jun  3 05:39 mysqladmin.1
-rwxr-xr--    1 root     mysqlgrp    10894 Jun  3 05:39 mysqld.1
-rw-r--r--    1 root     mysqlgrp     2481 Jun  3 05:39 mysqld_multi.1
-rwxr-xr--    1 root     mysqlgrp     7636 Jun  3 05:39 mysqldump.1
-rwxr-xr--    1 root     mysqlgrp     2317 Jun  3 05:39 mysqlshow.1
-rw-r--r--    1 root     mysqlgrp     1071 Jun  3 05:39 mysql_zap.1
-rwxr-xr--    1 root     mysqlgrp     1395 Jun  3 05:39 perror.1
-rw-r--r--    1 root     mysqlgrp     1535 Jun  3 05:39 replace.1
-rwxr-xr--    1 root     mysqlgrp     2290 Jun  3 05:39 safe_mysqld.1


/usr/local/mysql/mysql-test
################
total 52
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 include
-rwxr-xr-x    1 root     mysqlgrp     7325 Jun  9 08:13 install_test_db
-rwxr-xr-x    1 root     mysqlgrp    24132 Jun  9 08:13 mysql-test-run
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 r
-rw-r--r--    1 root     mysqlgrp     2078 Jun  3 05:39 README
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 std_data
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  9 08:13 t


/usr/local/mysql/scripts
################
total 16
-rwxr-xr-x    1 root     mysqlgrp    12868 Jun  9 08:13 mysql_install_db


/usr/local/mysql/share
################
total 4
drwxr-xr-x   25 root     mysqlgrp     4096 Jun  9 08:13 mysql


/usr/local/mysql/sql-bench
################
total 476
-rwxr-xr-x    1 root     mysqlgrp    14695 Jun  9 08:13 bench-init.pl
-rw-r--r--    1 root     mysqlgrp      665 Jun  3 05:39 ChangeLog
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  3 05:45 Comments
-rwxr-xr-x    1 root     mysqlgrp    16223 Jun  9 08:13 compare-results
-rwxr-xr-x    1 root     mysqlgrp     9829 Jun  9 08:13 copy-db
-rwxr-xr-x    1 root     mysqlgrp   107877 Jun  9 08:13 crash-me
drwxr-xr-x    4 root     mysqlgrp     4096 Jun  3 05:45 Data
-rwxr-xr-x    1 root     mysqlgrp    22113 Jun  9 08:13
graph-compare-results
drwxr-xr-x    2 root     mysqlgrp     4096 Jun  3 05:45 limits
-rwxr-xr-x    1 root     mysqlgrp     4320 Jun  3 05:39 README
drwxr-xr-x    2 root     mysqlgrp    12288 Jun  3 05:45 Results
drwxr-xr-x    2 root     mysqlgrp     8192 Jun  3 05:45 Results-win32
-rwxr-xr-x    1 root     mysqlgrp     6897 Jun  9 08:13 run-all-tests
-rwxr-xr-x    1 root     mysqlgrp    97484 Jun  9 08:13 server-cfg
-rwxr-xr-x    1 root     mysqlgrp     4989 Jun  9 08:13 test-alter-table
-rwxr-xr-x    1 root     mysqlgrp    24887 Jun  9 08:13 test-ATIS
-rwxr-xr-x    1 root     mysqlgrp     4138 Jun  9 08:13 test-big-tables
-rwxr-xr-x    1 root     mysqlgrp     8618 Jun  9 08:13 test-connect
-rwxr-xr-x    1 root     mysqlgrp     7047 Jun  9 08:13 test-create
-rwxr-xr-x    1 root     mysqlgrp    47912 Jun  9 08:13 test-insert
-rwxr-xr-x    1 root     mysqlgrp    13588 Jun  9 08:13 test-select
-rwxr-xr-x    1 root     mysqlgrp    11836 Jun  9 08:13 test-wisconsin
-rw-r--r--    1 root     mysqlgrp      818 Jun  3 05:39 TODO


/usr/local/mysql/support-files
################
total 68
-rw-r--r--    1 root     mysqlgrp      773 Jun  3 05:39 magic
-rw-r--r--    1 root     mysqlgrp     2534 Jun  9 08:13 my-huge.cnf
-rw-r--r--    1 root     mysqlgrp     2512 Jun  9 08:13 my-large.cnf
-rw-r--r--    1 root     mysqlgrp     2496 Jun  9 08:13 my-medium.cnf
-rw-r--r--    1 root     mysqlgrp     2211 Jun  9 08:13 my-small.cnf
-rwxr-xr-x    1 root     mysqlgrp    16415 Jun  9 08:13
mysql-3.23.51.spec
-rwxr-xr-x    1 root     mysqlgrp      675 Jun  9 08:13 mysql-log-rotate
-rw-r--r--    1 root     mysqlgrp     4023 Jun  9 08:13 mysql.server
-rw-r--r--    1 root     mysqlgrp    16415 Jun  9 08:13 mysql.spec


/usr/local/mysql/tests
################
total 164
-rw-r--r--    1 root     mysqlgrp     2380 Jun  3 05:39
auto_increment.res
-rw-r--r--    1 root     mysqlgrp     1123 Jun  3 05:39
auto_increment.tst
-rwxr-xr-x    1 root     mysqlgrp     1443 Jun  3 05:39 big_record.pl
-rwxr-xr-x    1 root     mysqlgrp     6322 Jun  3 05:39 export.pl
-rwxr-xr-x    1 root     mysqlgrp     6929 Jun  3 05:39 fork2_test.pl
-rwxr-xr-x    1 root     mysqlgrp    14371 Jun  3 05:39 fork_big.pl
-rw-r--r--    1 root     mysqlgrp     9083 Jun  3 05:39 function.res
-rw-r--r--    1 root     mysqlgrp     4037 Jun  3 05:39 function.tst
-rw-r--r--    1 root     mysqlgrp    20129 Jun  3 05:39 grant.pl
-rw-r--r--    1 root     mysqlgrp    22061 Jun  3 05:39 grant.res
-rwxr-xr-x    1 root     mysqlgrp     5149 Jun  3 05:39
insert_and_repair.pl
-rwxr-xr-x    1 root     mysqlgrp     3407 Jun  3 05:39 lock_test.pl
-rw-r--r--    1 root     mysqlgrp      495 Jun  3 05:39 lock_test.res
-rwxr-xr-x    1 root     mysqlgrp    14325 Jun  3 05:39 mail_to_db.pl
-rwxr-xr-x    1 root     mysqlgrp     3996 Jun  3 05:39 pmail.pl
-rwxr-xr-x    1 root     mysqlgrp     5716 Jun  3 05:39 table_types.pl
-rwxr-xr-x    1 root     mysqlgrp    10319 Jun  3 05:39
test_delayed_insert.pl
-rw-r--r--    1 root     mysqlgrp     2370 Jun  3 05:39 udf_test.res






---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to