Dear all,

How I can set a different user to run MySQL (only root can run this program
now) ?

Error message when run the program from user:

bash-2.03$ ./mysql --host=192.10.0.113
bash: ./mysql: Permission denied

Is it something have been change on the usr/group setting for the mysql
directory?

# ls -l /usr/local/
lrwxrwxrwx   1 root     other         34 Dec  5 16:32 mysql ->
mysql-3.23.46-sun-solaris2.8-sparc
drwxr-xr-x  13 root     mysql        512 Dec  5 16:30
mysql-3.23.46-sun-solaris2.8-sparc
#
# ls -l
total 9400
-rwxr--r--   1 root     other      19106 Dec  5 16:30 COPYING
-rwxr--r--   1 root     other      47577 Dec  5 16:30 COPYING.LIB
-rwxr--r--   1 root     other     122213 Dec  5 16:30 ChangeLog
-rwxr--r--   1 root     other     147258 Dec  5 16:30 INSTALL-BINARY
-rwxr--r--   1 root     other       1976 Dec  5 16:30 README
drwxr-xr-x   2 root     other       1024 Dec  5 16:29 bin
-rwxr--r--   1 root     other        773 Dec  5 16:30 configure
drwxr-xr-x   5 mysql    other        512 Dec 28 12:00 data
drwxr-xr-x   2 root     other       1024 Dec  5 16:30 include
drwxr-xr-x   2 root     other        512 Dec  5 16:30 lib
drwxr-xr-x   2 root     other        512 Dec  5 16:30 man
-rwxr--r--   1 root     other    2324374 Dec  5 16:30 manual.html
-rwxr--r--   1 root     other    2009009 Dec  5 16:30 manual.txt
-rwxr--r--   1 root     other      85339 Dec  5 16:30 manual_toc.html
drwxr-xr-x   6 root     other        512 Dec  5 16:30 mysql-test
drwxr-xr-x   2 root     other        512 Dec  5 16:30 scripts
drwxr-xr-x   3 root     other        512 Dec  5 16:30 share
drwxr-xr-x   7 root     other        512 Dec  5 16:30 sql-bench
drwxr-xr-x   2 root     other        512 Dec  5 16:30 support-files
drwxr-xr-x   2 root     other        512 Dec  5 16:30 tests

Please teach me, what I should change to make the program can run from
different user (NOT only root)?  Thanks a lot !


Thanks ang regards,
Kevin Chan


---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to